DevTools for .NET

Not answered Grid Export to Excel/Word 2007

Vijay Srinivasan

Posted on Nov 25, 2009 (permalink)

We are using "RadControls for Silverlight Q2 2009" to display results in radgridview.

1. Is there a way to export grids content in excel/word 2007 format?. If I try to save the exported content into a .xlsx file, excel is not able to recognize the format.
2. Is there a way to export grids content to PDF?

Vijay S

Reply

Lauren

Posted on Jun 14, 2010 (permalink)

Hi,

Is there a way to export to excel 2007 (extension xlsx) ?

I know you said no earlier, but i was wondering if it's been added since the last post :-)

Thanks
Lauren

Reply

Michael Casey

Posted on Aug 8, 2010 (permalink)

In case it makes a difference to your prioritization, I would like to make sure you are hearing that this is a very important feature.

The Silverlight RadGridView advertises Excel/Word/CSV export support, but the current Excel export falls short of expectations. The expectation is that the export should work similar to the Reporting Excel export (meaning that upon clicking the export button the user is presented with a choice of "Open" or "Save" of the exported file). Instead, the SL grid Excel export doesn't even support the creation of a true binary Excel file, and the only option is to save the file. Upon trying to open the file, the user is then presented with warning messages, due to mismatch format (ExcelML).

Please try and expedite this feature enhancement, and post back on this thread when you have more information about the expected release date.

Reply

Michael Casey

Posted on Aug 9, 2010 (permalink)

Vlad,

There is another posting in the Telerik forums that recognizes the problem with the HTML export. The posting from Telerik (Daniel) explains that the HTML format will cause a warning in Excel 2007, and suggests an alternative 3rd party library (NPOI). I have tried this library, but this has some limitations as well.

http://www.telerik.com/community/forums/aspnet-ajax/grid/excel-export-the-file-you-are-trying-to-open-filename-is-in-a-different-format-than-specified-by-the-file-extension.aspx

Here is the link to the Microsoft blog that explains why using the HTML format with the XLS extension causes the warning.
http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/03/11/excel-2007-extension-warning.aspx

With regard to the Open/Save option, I had not considered the ramification of the SL client-side implementation not prompting to Open. Is this something the RadGrid development team might give some thought to, since it involves an extra step for the end-user to save off the file, and then navigate to the file in windows explorer to open in Excel?

Perhaps it would be useful to integrate this with a Telerik SL Excel viewer, such as the MS Word viewer that you have already produced:
http://demos.telerik.com/silverlight/#RichTextBox/MSWord

Mike

Reply

Michael Casey

Posted on Aug 15, 2010 (permalink)

Vlad,

I didn't see a response to this, so I'm following up just to confirm that Telerik recognizes that there is more that can be done to improve the Excel export feature, and that it is a priority.

If you agree that there is work to be done to produce a better export, I'm looking to get an update on where this resides on your roadmap, or otherwise would like to make it available for a voting issue in the Public issue tracking forum. How do I get this issue to appear on that list?

Mike

Reply

Sri Harsha

Posted on Apr 28, 2011 (permalink)

Hello,

Please share your ideas if you have come across a way to prompt OPEN dialog box after export to excel operation.

Cheers
Harsha

Reply

Ryan

Posted on Jun 15, 2011 (permalink)

Hi, I wanted to follow since its mid 2011, and see what the status on the Excel export functionality is?

Thanks

Reply