I have an existing .xlsm file that I've created. It has a single sheet,
and some macros.
I'm using POI to add additional sheets/rows/cell to the workbook. That is
working as intended.
SXSSFWorkbook wb=newSXSSFWorkbook(new
XSSFWorkbook(OPCPackage.open("file.xlsm")),100);
I add the new sheet, and rows/cols to those sheet just fine.
But then I'd like to add some data to the original sheet that was in the
original file.
I tried via:
Sheet sheet = wb.getSheetAt(0);
Row row = sheet.getRow(1);
if (row==null)
row=sheet.createRow(1);
Cell cell = row.getCell(1);
if (cell == null)
cell = row.createCell(1);
cell.setCellValue("a test");
But I get an error related to "data already written to disk".
Any ideas/pointers?
THANKS!
-Zac Morris
