This is a migrated thread and some comments may be shown as answers.

[Solved] export to excel with extension .xlsx

3 Answers 264 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Krishna asked on 10 Apr 2009, 05:32 PM

Hi Team,
I am using the version 2008.3.1125.35
this is the code i use to export
                grid.Rebind();
                grid.ExportSettings.IgnorePaging = true;
                grid.ExportSettings.FileName = "Name";
                grid.ExportSettings.ExportOnlyData = true;
                grid.MasterTableView.ExportToExcel();
it exports the data in .xls format by default... i have excel 2007 installed in my machine
it also gives the warning messages as below

The file you are trying to open, <pagename>.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?"

is there anything i can ovoid the format realted warning message? and also .xlsx file is very lighter than the .xls so we want to use the lighter version.

or is there any simple c# code i can write each row to excel file for telerik grid.

Thanks
-krishna

[Solved] export to excel with extension .xlsx

3 Answers, 1 is accepted