Dear Team,
I am using below function to export to grid to Excel.
RadGrid1.MasterTableView.ExportToExcel();
But i have to customize the exported excel file with some text box values and drop down values above rad grid data. Please find attached required exported excel file for more clarification.
Kindly let me know how this can be achieved.
Thank you.
1 Answer, 1 is accepted
0
Hi Jatin,
You can add custom information to the exported file. The specific approach would depend on the Excel format that you are using for export.
If you are using HTML format you can handle the HTMLExporting event of RadGrid and customize the generated code based on your requirements.
In case you are using BIFF export you should handle the BiffExporting event. For the rows above the grid you should add new rows above the exported data and define their contents. Take a look at the article below for additional information:
Regards,
Viktor Tachev
Telerik by Progress
You can add custom information to the exported file. The specific approach would depend on the Excel format that you are using for export.
If you are using HTML format you can handle the HTMLExporting event of RadGrid and customize the generated code based on your requirements.
In case you are using BIFF export you should handle the BiffExporting event. For the rows above the grid you should add new rows above the exported data and define their contents. Take a look at the article below for additional information:
Regards,
Viktor Tachev
Telerik by Progress
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.