Export to Excel - Multiple Grids

4 posts, 0 answers
  1. Rodney
    Rodney avatar
    4 posts
    Member since:
    Sep 2011

    Posted 17 Jan 2012 Link to this post

    I have a dashboard with 3 separate grids on it, while I can export each grid to a separate excel file that works great.  I was wondering if it's possible to export the 3 grids to a single excel file but on different sheets?

    Thanks in advance.
  2. Ivan Petrov
    Admin
    Ivan Petrov avatar
    705 posts

    Posted 20 Jan 2012 Link to this post

    Hi Rodney,

    Thank you for writing.

    Currently, the ExportToExcelML does not support this kind of export. The only possibility is to create a single file with one or more sheets which contain the elements from one grid. I have added your feature request to our Public Issue Tracking System - PITS. You can comment and/or add your vote for it on the following link PITS - Feature

    I hope this will be useful for you. If you have other questions, feel free to write back.

    Greetings,
    Ivan Petrov
    the Telerik team

    SP1 of Q3’11 of RadControls for WinForms is available for download (see what's new).

  3. Rodney
    Rodney avatar
    4 posts
    Member since:
    Sep 2011

    Posted 20 Jan 2012 Link to this post

    Hi Ivan
    Thanks for the information, but can you elaborate on your statement "The only possibility is to create a single file with one or more sheets which contain the elements from one grid."  Do you have any examples that you can send me?

    Thanks,
    Rodney
     
  4. Ivan Petrov
    Admin
    Ivan Petrov avatar
    705 posts

    Posted 25 Jan 2012 Link to this post

    Hello Rodney,

    Thank you for your reply.

    Our export to ExcelML feature allows setting the maximum number of rows per sheet that can be exported, to do this you should set the SheetMaxRows property of ExportToExcelML. You can use the following values: 65536 or 1048576. When RadGridView is being exported and this number of rows is reached, the exporter creates additional sheet and continues to export rows in it.

    I hope this helps. If you need further assistance do not hesitate to write back.

    All the best,
    Ivan Petrov
    the Telerik team

    SP1 of Q3’11 of RadControls for WinForms is available for download (see what's new).

Back to Top