Hi All,
I am using a excel template.xlsm (Office 2010) file that contains three
sheets with pivot tables. I have set the pivot tables option > DATA >
refresh data when opening file for each sheet.
The development code may need only one or multiple sheets when I write my
new file using the template. The code check and delete the extra sheets as
(coldfusion code):
<cfset delSheet = writeableWorkbook.getSheet("My Sheet") />
<cfset delIndex = writeableWorkbook.getSheetIndex(delSheet) />
<cfset writeableWorkbook.removeSheetAt(delIndex) />
<cfset writeableWorkbook.write(xlsFile) />
<cfset writeableWorkbook.dispose() />
<cfset xlsFile.close() />
<cfset xlsFileTemplate.close() />
I am getting an error at the time of open the new excel file.
"Excel found unreachable content in myFile.xlsm. Do you want to recover the
content of this book?"
If I check YES:
Another window show with this message:
"Excel completed file level validation and repair. Some parts of this
workbook may have been repaired or discarded.
Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)"
Any ideas how to fix this issue?
Using POI 3.8 in coldfusion 9.
Thanks.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Template-issue-tp5716005.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]
