Export to Excel 2007

[Siva]

Hi Telerik team,

I am trying to Export RadGrid Data to Excel 2007(.xlsx) using ToHtml() method. It is saving the file, but the file is not opened in the Office. Also If I Export to Excel 97-2000 format (.xls) I am getting a warning message about format while opening the file, but i am able to check the file after clicking 'yes'. Is there any way to solve these? Also can I Export the Grid to PDF directly? Please tell me how i can achieve all these requirements.

Thanks,
Siva.

[Vlad]

Hi Siva,

The grid can be exported to HTML, ExcelML, CSV and tab-delimited text only. You can open both HTML and ExcelML in Excel 2007 however if the extension is xls you will get warning since this is not the native Excel 2007 format.

Best wishes,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Siva]

Thank you for your quick replay Vlad,

With your reply, I understand that there is no support for pdf export with in wpf radgrid, as there is for ASP.Net RadGrid. Can I Export to .xlsx format? or even this is not supported?

-Siva.

[Vlad]

Hi Siva,

Currently there is no native xlsx export.

Sincerely yours,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[treesara]

Vlad,

Any update on native xlsx exporting support?

Regards,
Panit

[Vlad]

Hello,

This is still not supported. Once we have it we will update our demos, documentation, etc. - unfortunately we cannot provide any exact release date for this for now.

Sincerely yours,
Vlad
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Berthold]

Hello,

any news in supporting Excel 2007?
We start a new project which requires Excel 2007 support. Now we're looking for an appropriate tool.

Regards
Berthold

[Vlad]

Hello Berthold,

 Unfortunately export to Excel 2007 is still not supported and currently we do not have any specific release 
date for this feature. 

Best wishes,
Vlad
the Telerik team

[Scott]

How about now?  Export to Excel 2007/2010 still not supported?  If not, any plans yet?

[Vlad]

Hi,

 This is still not supported from the grid native export. Indeed we have plans to provide this out-of-the-box using RadDocument (please check the PDF export demo in our QSF) later this year however we cannot commit any specific date. 

All the best,
Vlad
the Telerik team

[Jordan]

Still looking for Excel 2007/2010 support...any update?

[Telugu]

Hi Vlad,

How about now?  Export to Excel 2007/2010 still not supported?  If not, any plans yet?

RadGrid export to excel with warning message

My requirement is the warning message not show.

Please give solution for this.

Thanks & Regards,
Praveen.

[Sasireka]

Hi all,

Is any update?. I want to export to excel 2007 from radgridview.

Regards,
Sasireka

[Vlad]

Hi Sasireka,

 Next week with the official Q1 2013 we will release the CTP version of our brand new component RadSpreadSheet and we will do our best top include demo for RadGridView exporting to XLSX for the first service pack (middle of March most probably). 

All the best,
Vlad
the Telerik team

[Pearl]

Hi,

    I need a quick update on Exporting RadGridView in xlsx format.
    Please let me know if there are any updates.

Thanks,
Muthu

[Dimitrina]

Hi Muthu,

The best option we can currently suggest is exporting with RadSpreadSheet creating a RadWorkBook as demonstrated on this blog post: http://blogs.telerik.com/vladimirenchev/posts/13-04-22/how-to-quick-export-to-excel-%28xlsx%29-for-wpf-and-silverlight.

I hope this helps.

Regards,
Didie
Telerik

[guobian]

Hi All,

Is there a better way of doing this now?

Didie's suggestion on using RadSpreadSheet works on exporting data. However, the RowSytle and CellStyle applied on the Grid are not exported.

Cheers,
guobian

[Dimitrina]

Hello guobian,

For more advanced exporting options you can use the Telerik Reporting product. You can check its online documentation here.

Regards,
Didie
Telerik