Creating reports and dashboards | Stimulsoft community forum

Posted: **Mon Apr 14, 2014 6:21 am**

Hello,
I need export large of data(about 20 columns and 30 000 rows and more).
But Export to XLS file consume too much memory. About 600-700MB.
Is there any way, how can I reduce this?

Sample projet included.

Thanks for your reply.

Posted: **Tue Apr 15, 2014 9:11 am**

Hello.

The whole rendered report is stored in memory.
While you use Unlimited Height property of the page, it's impossible to reduce consuming of memory.

You could try to comment next lines:

Code: Select all

page.UnlimitedBreakable = false;
page.UnlimitedHeight = true;

set cache mode:

Code: Select all

report.ReportCacheMode = StiReportCacheMode.On;

and use next option on export:

Code: Select all

Stimulsoft.Report.Export.StiExcelExportSettings.UseOnePageHeaderAndFooter = true;

Then using of memory will be reduced.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Export consume to much memory

Export consume to much memory

Re: Export consume to much memory