Exporting Radgridview tab limit ?

2 posts, 0 answers
  1. Deasun
    Deasun avatar
    35 posts
    Member since:
    May 2019

    Posted 09 Oct 2020 Link to this post

    Good morning,

    Is there a limit to the number of tabs  in the exported file?

    I have a multipart report that has 12 grids I need to export to the same excel doc.

    On the 5th grid export it is just sitting there , no errors just hangs.

    Most grids have 20 - 30 records but 2 can have a couple of 100Ks records.

    Is this the issue?


  2. Dess | Tech Support Engineer, Sr.
    Dess | Tech Support Engineer, Sr.  avatar
    4177 posts

    Posted 12 Oct 2020 Link to this post

    Hello, Deasun,   

    According to the provided information, I suppose that you are using the GridViewSpreadExport: https://docs.telerik.com/devtools/winforms/controls/gridview/exporting-data/spread-export

    It utilizes our RadSpreadProcessing library to export the content of RadGridView to xlsx, csv, pdf and txt formats: https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/overview

    However, there is no strict limit for the number of sheets: "Sheets in a workbook - Limited by available memory (default is 1 sheet)"

    Considering the fact that some of the grids may have 100K rows, I would highly encourage you to try the GridViewSpreadStreamExport. It allows you to create big documents (without loading the entire document in the memory) and export them to the most common formats. Additional information is available in the following help article: https://docs.telerik.com/devtools/winforms/controls/gridview/exporting-data/spreadstream-export 

    I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

    Dess | Tech Support Engineer, Sr.
    Progress Telerik

    Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive, special prizes, and more, for FREE?! Register now for DevReach 2.0(20).

Back to Top