Headers only exported to Excel

[bdk0172]

I followed your example on how to export to Excel and how to handle when the radGrid is in an ajaxified updatepanel.  The grid is populated during a button click and not during page load so it is empty when first going to the page. 

This is the code I have in another button click:

radGridResults.ExportSettings.IgnorePaging = true;

radGridResults.ExportSettings.OpenInNewWindow = true;

radGridResults.MasterTableView.ExportToExcel();

I click on the button, get the Open/Save/Cancel window and save the file.  When I open it, I first get a window popped up that states "The file you are trying to open, 'RadGridExport.xls', is in a different format than specified by the file extension.  Verify that the file is not corrupted and is from a trusted source before opening the file.  Do you want to open the file now?".  I selected Yes and when it finally opens all I can see are the header titles, it does not appear that any of the row data has been exported.

What am I doing wrong?

 

 

[Daniel]

Hello Brian,

Regarding the empty lines: Could you please post your RadGrid declaration?

The message you mentioned is expected and it is depicted in our documentation:
Only MS Word and MS Excel 2003 or later are supported.

Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[bdk0172]

<telerik:RadGrid ID="radGridResults" runat="server" Height="275px" Width="700px"
                        EnableViewState="false" OnExcelMLExportStylesCreated="radGridResults_ExcelMLExportStylesCreated"
                        OnExcelMLExportRowCreated="radGridResults_ExcelMLExportRowCreated">
                    </telerik:RadGrid>

I'm not completely sure if I need the OnExcel... events or not, I just copied them from the sample.

[Daniel]

Hello Brian,

Is it working as expected with ViewState enabled?

Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[bdk0172]

No, if I set it to true, then I get the following error:

Failed to load viewstate.  The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request.  For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.

[bdk0172]

Any details on this?

[Daniel]

Hello Brian,

The best option would be to send us a simple working project in order to run and examine your code locally. Thus we may be able to give you a satisfying answer.

Thank you for the cooperation

Best regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[bdk0172]

Sample is attached to support ticket number 168466.  It was created in VS 2005 and I have Office 2007 installed.

[Sebastian]

Hi bdk0172,

Thank you for submitting the example - we will review it and will get back to you with more info on the subject.

Best regards,
Daniel,
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[bdk0172]

Got your example and was able to update so I can export all of the rows.  Thanks for all of your help.  One last issue which is probably just some property that needs to be set.  I have some very long numbers such as "02021418888555" which gets converted to "2.02142E+12" and time fields where "12:13:00.000" gets converted to "13:00.0".  This is what they look like in the cells, but when I select an individual cell, the proper formatting shows in the Formula Bar. 

Does this have anything to do with the fact that I'm opening the file in Excel 2007 or is it just a setting of the grid export.  Once this has been figured out, all of my issues will have been solved.

Once again, thanks for your help.

[Daniel]

Hello Brian,

This behavior was already discussed in several forum threads. Here is an example:
Leading Zero's - Export to Excel

<telerik:GridBoundColumn DataFormatString="&nbsp;{0}&nbsp;" DataField="Id"></telerik:GridBoundColumn>

I hope my directions are helpful.

Best regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.