Eclipse Community Forums: BIRT » BIRT Excel export issue with half a million records

Help

Home

Home » Archived » BIRT » BIRT Excel export issue with half a million records

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT Excel export issue with half a million records [message #1836901]

Mon, 18 January 2021 10:54

Eclipse User

HI Guys,

I am facing issue while exporting a BIRT report in excel using v4.5.
For a report with 40 columns and .5m records it consumes like 40gb of memory which eventually causes java heap error.

Now i know BIRT used spudsoft emitter for generating excel and I read that
:bitbucket.org/yaytay/spudsoft-birt-excel-emitters/wiki/UserProperties has some data but lately this link is not getting opened.

I need to know how to set options.setOption("ExcelEmitter.ExtractMode", "TRUE");
Which version has this feature as I don't see this option as per below version of spudsoft
https://github.com/EclispeBIRT/org.eclipse.birt/blob/master/engine/uk.co.spudsoft.birt.emitters.excel/src/uk/co/spudsoft/birt/emitters/excel/ExcelEmitter.java

Any help will be appreciated. Thanks.

Report message to a moderator

Previous Topic:	[SOLVED] "Java heap space" OutOfMemory error in renderTask
Next Topic:	Debug error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 07:16:39 GMT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter