Grid Export to Excel/Word 2007

16 posts, 0 answers
  1. Vijay Srinivasan
    Vijay Srinivasan avatar
    4 posts
    Member since:
    Aug 2009

    Posted 25 Nov 2009 Link to this post

    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
  2. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 26 Nov 2009 Link to this post

    Hi,

    Currently the grid can be exported to HTML, CSV and ExcelML only - we don't have native Excel/Word 2007 format export or PDF export. You can open all three formats in Excel 2007 however you will get warning for HTML format on open.

    All the best,
    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.
  3. DevCraft banner
  4. Lauren
    Lauren avatar
    37 posts
    Member since:
    Jan 2010

    Posted 14 Jun 2010 Link to this post

    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
  5. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 15 Jun 2010 Link to this post

    Hi Lauren,

    Unfortunately we still don't have native Excel 2007 export however since we have now native docx support for our editor we will do our best to provide Excel 2007 export for RadGridView by the end of the year. 

    All the best,
    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.
  6. Michael
    Michael avatar
    28 posts
    Member since:
    Nov 2005

    Posted 08 Aug 2010 Link to this post

    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.
  7. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 09 Aug 2010 Link to this post

    Hello,

     Generally "Open" or "Save" dialogs will be displayed from your browser when you download something from the server. The grid will export completely client-side - no server round trips! You will get format warning only if you export to HTML - Excel will not display any warning if you use ExcelML and set XML extension for the exported file - you can check our demo for more info. 

    Regards,
    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
  8. Michael
    Michael avatar
    28 posts
    Member since:
    Nov 2005

    Posted 09 Aug 2010 Link to this post

    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
  9. Michael
    Michael avatar
    28 posts
    Member since:
    Nov 2005

    Posted 15 Aug 2010 Link to this post

    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
  10. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 16 Aug 2010 Link to this post

    Hi,

    I still believe that Open/Save are browser dialogs and you cannot invoke them from Silverlight (excluding ugly hacks). We have plans for native (XLSX) export however this will be completely new platform wide component (outside of RadGridView) however this will be available most provably in the middle of 2011. 

    Kind regards,
    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
  11. Sri Harsha
    Sri Harsha avatar
    1 posts
    Member since:
    Apr 2011

    Posted 28 Apr 2011 Link to this post

    Hello,

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

    Cheers  
    Harsha
  12. Ryan
    Ryan avatar
    4 posts
    Member since:
    Jun 2011

    Posted 15 Jun 2011 Link to this post

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

    Thanks
  13. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 16 Jun 2011 Link to this post

    Hi,

     The Excel 2007 exporting will be part most probably of RadDocument format providers similar to PDF export and will be available later this year - we cannot share however any exact  release date.

    Greetings,
    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
  14. Marc
    Marc avatar
    66 posts
    Member since:
    Jul 2010

    Posted 16 Dec 2011 Link to this post

    Is there an update on this? Exporting large excel files to html is not efficient.
  15. Patrice
    Patrice avatar
    4 posts
    Member since:
    Apr 2010

    Posted 07 Feb 2012 Link to this post

    Any updates on this ? 
  16. Michael Hilgers
    Michael Hilgers avatar
    76 posts
    Member since:
    Apr 2010

    Posted 17 Jul 2014 Link to this post

    Hello Telerik,

    i'm bringing this topic back to life: What's the status of the Excel 2007 (xlsx) export?

    We need this urgent because customers want to export data which has more than 65,536 rows to excel.

    Please give us a feedback about this. Thanks.

    Regards,
    Michael
  17. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 17 Jul 2014 Link to this post

    Hi Michael,

    To find the newest option we have introduced as to exporting to Excel, you can check our demo on exporting/printing with RadSpreadProcessing. You can also refer to its documentation.

    Regards,
    Didie
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
Back to Top
DevCraft banner