I Have Webdata grid and drop down provider items and my requirement is to export checked items as row in excel.
Hello Raghu RS,
Thank you for posting in our forums!
There are no built-in options for the functionality you are looking for, but you can achieve this functionality by handling the WebExcelExporter's RowExporting or RowExported events. In the event handler, you can access the checked item data and add the excel row as desired.
If you have any further questions or concerns with this, please let me know and I will be glad to help.
Hi Michael,
Thanks for your help!
Can you share any sample code for this RowExporting and Rowexported events in WebDatagrid.
I am using Microsoft.Office.Interop.Excel for exporting the data.
Thanks,
Raghu RS
Microsoft.Office.Interop.Excel
Hi Raghu RS,
The RowExporting and RowExported events are available on the WebExcelExporter, not the WebDataGrid. The WebExcelExporter is our own control that will export the WebDataGrid to an Excel file. You can see our online samples and documentation for the WebExcelExporter here:
http://ko.infragistics.com/samples/aspnet/excel-exporter/overview
http://help.infragistics.com/doc/ASPNET/2015.2/CLR4.0/?page=Web_WebExcelExporter.html
We don't provide any support for using Microsoft.Office.Interop.Excel with the WebDataGrid. You would need to manually extract the data and other functionality from the WebDataGrid to export using that library.
If you have any further questions or concerns with this, please let me know.