The POI use more memory when read xlsx files. I follow the guideline using
OPCPackage.
I try:
<cffile action="COPY" source="#filepathtemplate#" destination="#filepath#"
/>
<cfset xlsFileTemplate =
createObject("java","org.apache.poi.openxml4j.opc.OPCPackage").open(JavaCast("string",
filepathtemplate)) />
<cfset templateWorkbook =
createObject("java","org.apache.poi.ss.usermodel.WorkbookFactory").create(xlsFileTemplate)
/>
<cfset writeableWorkbook =
createObject("java","org.apache.poi.xssf.streaming.SXSSFWorkbook").init(templateWorkbook,
1000) />
It reduced the time but not much. Anybody have an idea in how to improved
this?
Thanks.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Create-an-excel-file-using-template-tp5717313p5717333.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
