This is a migrated thread and some comments may be shown as answers.
Exporting Radgridview tab limit ?
1 Answer 4 Views
This is a migrated thread and some comments may be shown as answers.
Deasun
Top achievements
Rank 1
Veteran
Deasun asked on 09 Oct 2020, 01:57 PM

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

Sort by
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 12 Oct 2020, 09:21 AM

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).

Asked by
Deasun
Top achievements
Rank 1
Veteran
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
Share this question
or