[Solved] Export Multiple RadGrids in single Excel File - Biff Format

[Trevor]

Hi,

I have read the following threads:

http://www.telerik.com/community/code-library/aspnet-ajax/grid/multiple-worksheets-in-excelml.aspx
http://www.telerik.com/community/code-library/aspnet-ajax/grid/export-multiple-radgrids-in-single-pdf-excel-file.aspx

But when trying to export using these methods I get the:
"The file you are trying to open, '[filename]', 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?"

Now I know that when I get this message I need to use the Binary Excel format Biff. The problem is that when you use the Biff format the above examples no longer work. Is there a way of exporting multiple RadGrids to a single Excel file with multiple Worksheets using the Biff format.

Any help would be very much appreciated. Thank you.

Kind regards

Trevor Pope

[Trevor]

Nobody able to help with this?

[Kostadin]

Hello Trevor,

You could review the following example which demonstrates how to export multiple grids in a single or separate spreadsheets.

Regards,
Kostadin
Telerik