Hello, i'm using POI-3.7
and i need to delete sheet and save xlsm file. I do next :
XSSFWorkbook workbook = new XSSFWorkbook(OPCPackage.open(filePath));
List<String> list = Arrays.asList(new String[]{"TRSCN_LOG ",
"MAIN_SHEET
sedol", "INDICES", "CURNCY", "INITIAL_VALUES"});
for(int i=0; i<10; i++){
try{
Sheet sheet = workbook.getSheetAt(i);
if(sheet != null &&
!list.contains(sheet.getSheetName()))
workbook.removeSheetAt(i);
}catch (Exception e) {}
}
workbook.write(new FileOutputStream(filePath));
and after i get:
Can't obtain the input stream from /docProps/app.xml
what do i do wrong?? help please!
Thanks!
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Can-t-obtain-the-input-stream-from-docProps-app-xml-tp3284222p3284222.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]
