RadGrid Export to Excel - empty spreadsheet

[Steven]

When I try to use the ExcelML format I always get an empty spreadsheet.  If I run the code with ExportToCSV instead of ExportToExcel, I get data, or if I just leave out the GridExcelExportFormat.ExcelML line (use the default format) with ExportToExcel I also get a spreadsheet.  Any ideas why I'm getting a blank spreadsheet when I use both the ExcelML format and ExportToExcel method?

 

Me.RTLGrid1.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.ExcelML

 

 

Me.RTLGrid1.ExportSettings.ExportOnlyData = True

 

 

Me.RTLGrid1.ExportSettings.OpenInNewWindow = True

 

 

Me.RTLGrid1.MasterTableView.ExportToExcel()

 

 

'Me.RTLGrid1.MasterTableView.ExportToCSV()

 

[Daniel]

Hello Steven,

Please try to enable UseAllDataFields property in MasterTableView:

<MasterTableView UseAllDataFields="true" ... >

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Steven]

Now I'm getting a message box "Problems During Load"  Problems came up in the following areas during load:  Table.  This file cannot be opened because of errors.

The error log it says is created is on the client side but they are never created.  Excel does not load any spreadsheet after.

Thanks,

[Steven]

I've somewhat solved it.  The problem with the Excel loading is that one of my fields has NULL for a datetime field and that causes Excel to choke when attempting to load.  If I put a date in the database column - it works with no issues.  Is there a way of telling the export to ignore that issue?

Thanks,

[Daniel]

Hello Steven,

Sorry for the late answer. I tried to reproduce the problem but unfortunately without avail. Could you please provide a small runnable project which illustrates the problem? You can attach it to formal support ticket.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Danniel]

Hi everyone,

 

I have this same issue, when exporting to CSV it works fine but with export to excel it opens empty. this is happening to alla my applications and they used to work fine. Any help will be appreciated.

 

thks in advanced!!!

[Konstantin Dikov]

Hello Felipe,

Please refer to the following forum thread and see if the fix applies to your scenario:

• http://www.telerik.com/forums/html-based-export-format-is-not-working-in-excel-2010

Regards,
Konstantin Dikov
Telerik by Progress