Export to new version of excel

[york]

Hi,
I try to export radgrid to excel with RadGrid1.MasterTableView.ExportToExcel(). I am using MS office 2010. Before excel is opened, it always popups a warning that says the file format is not correct. It seems that ExportToExcel() creates a .xls file, while excel 2010 default is .xlsx file. I wonder if there is way for ExportToExcel() to generate a .xls file. Thanks.

[Shinu]

Hello York,

I tried the same in the latest version 2011, 2, 712, 35. Try setting the Excel-FileExtension as shown below.

aspx:

<ExportSettings Excel-FileExtension=".xls" ExportOnlyData="true"></ExportSettings>

Thanks,
Shinu.

[york]

Hi Shinu,

I am using Telerik version 2010..., and can not find Excel-fileExtension in ExportSettings. Is it a new property?

Thanks,
York

[Shinu]

Hello York,

Try upgrading to the latest version.
Updating RadControls for ASP.NET AJAX to another version or license

-Shinu.

[york]

Is it free? Thanks