Me again :)
Per the link bellow delete sheets is not supported in SXSSF buffered
streaming
http://poi.apache.org/spreadsheet/index.html
It should works using usermodel.XSSFWorkbook. I change my code to delete the
sheets after I read the template and before passing to the streaming
workbook but no luck, the error show at the time I open the file.
Anyone can clear this issue?
<cfset xlsFileTemplate =
createObject("java","java.io.FileInputStream").init(filepathtemplate) />
<cfset templateWorkbook =
createObject("java","org.apache.poi.xssf.usermodel.XSSFWorkbook").init(xlsFileTemplate)
/>
<cfset delSheet = templateWorkbook.getSheet("My Sheet") />
<cfset delIndex = templateWorkbook.getSheetIndex(delSheet) />
<cfset templateWorkbook.removeSheetAt(delIndex) />
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Template-issue-tp5716005p5717338.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
