Export consume to much memory

[satvcd]

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.

[HighAley]

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.