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?
1 Answer, 1 is accepted
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.
Regards,
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).