Grid-Export to Excel-.XLSX format

[SANNIDHI]

Hi,

         I implemented grid view-export to excel functionality in my application.
 
         By default it will take .xls  format..i need it to be .xlsx  format (2007 ).

         but when i added .xlsx file extension in my code..it is  unable to open that fiel

        please let me know the solution for this...

        Urggggent ..plzzzzzzz

Thanks,

[Princy]

Hi,

Try setting the FileExtension property as shown below.
aspx:

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

Thanks,
Princy.

[SANNIDHI]

Hi Princy,

                      Thank you for your reply...
                       It is not working..
                       following error msg displaying..plz find the attachment..

Thanks...

[Kostadin]

Hi SANNIDHI,

Try our new Excel export format (in Q2 2012) which is based on a binary XLS (BIFF) format and is supported in all versions of Microsoft Office, starting from 2003. By default it exports the file in .xlsx format.

<ExportSettings ExportOnlyData="true" >
    <Excel Format="Biff"/>
</ExportSettings>

Regards,
Kostadin
the Telerik team

[SANNIDHI]

Hi,


             How to do that in other way without using new version..

Thanks

[Kostadin]

Hi SANNIDHI,

The only other possible solution is to re-save the file in the format that you like. Even if you change the extension manually Microsoft Office will detect the difference between the MIME type and the file content and will then add its own autodetected extension.

Greetings,
Kostadin
the Telerik team

[Meera]

Hi Kostadin,

I tried with 

myGrid.ExportSettings.Excel.Format = GridExcelExportFormat.Biff ;

myGrid.MasterTableView.ExportToExcel();

in((in Q2 2012) ) still it does not allow me downloading file in xlsx format.

 

Can you tell me if I am missing something?

Thanks,

[Daniel]

Hello Meera,

The BIFF format is actually a binary XLS file and not XLSX. RadGrid does not support the latter, sorry for any inconvenience caused.

Regards,
Daniel
the Telerik team