RadGridViewExcelExporter -- Export to multiple sheets

11 posts, 0 answers
  1. DNV Cleaner Energy
    DNV Cleaner Energy avatar
    6 posts
    Member since:
    Apr 2009

    Posted 23 Jul 2010 Link to this post

    I have a TabStrip with different RadGridViews in different tabs. I would like to export these grids into multiple Worksheets in a single file. How can I do that?
  2. DNV Cleaner Energy
    DNV Cleaner Energy avatar
    6 posts
    Member since:
    Apr 2009

    Posted 27 Jul 2010 Link to this post

    Any updates on this one? We would like to export gridviews from multiple tabs into a single excel file, but in different worksheets within the same file. Looks like a straightforward requirement.

    I find that only the last sheet is written and all previously written sheets do not exist.
  3. Jack
    Admin
    Jack avatar
    2333 posts

    Posted 28 Jul 2010 Link to this post

    Hi Veeramani Pulacode,

    Thank you for contacting us. Currently this feature is not available in our Export to Excel feature. However, it is interesting and we will consider implementing it in one of our upcoming releases.

    Sincerely yours,
    Jack
    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
  4. Dipak
    Dipak avatar
    19 posts
    Member since:
    Oct 2008

    Posted 20 Oct 2010 Link to this post

    I am also in need this feature. Can we have any work arround for this please?

    Thanks
    Dipak
  5. DNV Cleaner Energy
    DNV Cleaner Energy avatar
    6 posts
    Member since:
    Apr 2009

    Posted 20 Oct 2010 Link to this post

    Our development team went along with the export to multiple excel files and then working with them.
  6. Martin Vasilev
    Admin
    Martin Vasilev avatar
    1061 posts

    Posted 26 Oct 2010 Link to this post

    Hi guys,

    Thank you for contacting us.

    There is no workaround for exporting multiple grids to a single file in different sheets. If we receive more enquiries concerning this feature, we will increase its higher.

    Do not hesitate to contact us if you have any other questions.

    Sincerely yours,
    Martin Vasilev
    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
  7. Dale
    Dale avatar
    1 posts
    Member since:
    Jun 2010

    Posted 21 Sep 2011 Link to this post

    Hi Telerik,


    We also have a TabStrip with different RadGridViews in different tabs.

     

    We need to export these grids to multiple worksheets in the same Excel file.

     

    Our IT department had quite a bit of difficult convincing management to use Silverlight & Telerik.

     

    Now the first high profile report in Silverlight / Telerik we need to do for executive management, we must give them in multiple Excel files and ask  them to manually copy the data from one spreadsheet to the other because the option to export the data as they view it on the screen does not exist.

     

    This is not a good option as it reflects poorly on our IT department and the products we have selected.

     

    Please increase the priority of this project as this is the first of many reports that we need this functionality.

     

    Regards,

    Mitch Royster
    Freight Systems Inc
  8. Mitch
    Mitch avatar
    2 posts
    Member since:
    Jun 2011

    Posted 27 Sep 2011 Link to this post

    Hi Vlad,

    Thank you for the sample project.

    The code example to export the radgridviews to multiple worksheets within the same workbook worked great.

    However, I still have two issues.

    I would like to name the worksheets and .SheetName does not work. I have tried several other options but have not been able to get it to work. Suggestions?

    Also, as you mentioned, the user must click on a tab before the data is available to be exported. Is there a way to do this programmatically so the user does not have to click on the tab before exporting the data? The 1st tab is displayed when the grids load. I thought I could set focus to the 2nd tab in code (to cause the data to load), then set focus back to the 1st tab, but it is not working. Suggestions?

    Thanks for your help.

    Regards,
    Mitch Royster
    Freight Systems Inc.

  9. Dipak
    Dipak avatar
    19 posts
    Member since:
    Oct 2008

    Posted 18 Oct 2011 Link to this post

    Could you please share this sample project?
  10. Nikolay
    Admin
    Nikolay avatar
    1805 posts

    Posted 21 Oct 2011 Link to this post

    Hello Dipak,

    Please note that Mitch is targeting our Silverlight suite while you are mainly using our WinForms suite. Are you still interested in the Silverlight solution?

    Mitch, if you have further questions regarding the current topic, I would kindly ask you to post them in the appropriate forum section. Please note that the current thread is in the WinForms forums. Posting your enquiry in the appropriate section will allow those interested in the same question to find the answer more easily.

    Thank you for your understanding and cooperation.

    All the best,
    Nikolay
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  11. Mitch
    Mitch avatar
    2 posts
    Member since:
    Jun 2011

    Posted 21 Oct 2011 Link to this post

    I resloved all the issues. Everything is working now.

    Thanks,
    Mitch Royster
Back to Top