RadGrid Export to Excel not exporting all columns to Excel file

[Durga]

Hi,

RadGrid and  Export to Excel, all columns are not exporting to Excel file, some columns are missing while exporting but it working fine in some other page Below is the code for Export to Excel.

        grid1.DataSource = ViewState("OrderHeader")
        grid1.DataBind()
        grid1.ExportSettings.FileName = "OrderSummary"
        grid1.ExportSettings.IgnorePaging = True
        grid1.ExportSettings.OpenInNewWindow = True
        grid1.HeaderStyle.Font.Bold = True
        grid1.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML
        grid1.ExportSettings.ExportOnlyData = True
        grid1.MasterTableView.ExportToExcel()

Any help would be appreciated. Please help me out.

Thanks
Durga

[Computer Surgeon]

Hi there,

              I also faced the same issue as u have now. I just compared the attributes of the template column that was able to be Export to Excel and the one that was not able be Exported to Excel. I missed the UniqueName="ColumnName" and HeaderButtonType="TextButton" property for the column, When i compared. I just added that property it worked.

My suggestion is you might missed some property thats it. So double check the property of column that you might have missed.

If this is not working for u please let me know .