Hello,
i need to read in Excel templates containing Formulas and Diagrams, change
some values in cells and write a new File:
FileInputStream fileInputStream = new FileInputStream(aInputFile);
POIFSFileSystem in = new POIFSFileSystem(fileInputStream);
HSSFWorkbook wb = new HSSFWorkbook(in);
// Do some changes in the workbook
FileOutputStream fileOutputStream = new FileOutputStream(aOutputFile);
wb.write(fileOutputStream);
fileInputStream.close();
fileOutputStream.close();
I get an Nullpointer Exception when the template contains formulas or
diagrams (Sheet.serialize). From previous mails i know that writing formulas
is currently not supported.
Could please tell me someone, when it will be possible to write formulas?
Writing diagrams ?
Can i support the project in some ways - just ordered the Excel 97
Developer's Kit? I looked into the code and saw a lot of commented out code
and not to much comments - so i guess it would be pretty hard. What's the
best way to start with - i need these two features in the near future.
Thanks for your help
Reto
