Grid exporrting formatting and alignment

[Amarnath]

Hi there,

Can any one help me, how to format data exporting from grid to Excel, PDF and CSV?
When I export the grid its alignment looks very badly.

And i am not getting the ExportToExcelML() in my code behind.

Regards,

Amarnath

[Shinu]

Hello Amarnath,


The following links will be of help, in formatting the exported file.
Word/Excel export (HTML-based)

ExcelML is Sub-format of Excel, that means you can call "ExportToExcel()" method to export to ExcelML, and you need to set the Excel.Format properly.
C#:

RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
RadGrid1.MasterTableView.ExportToExcel();

 

-Shinu.