Hi all,
I have a large excel file with a sheet with formulas and with a sheet of
data.
I am updating the excel file like it's described in BigGridDemo Example:
http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java
But I don't know how to update my formulas and save them without getting a
OutOfMemoryException.
Here's my code:
List<String> data = getDataFromDB();
//update like in BigGridDemo Example
XSSFWorkbook wb = updateWorkbookWithData();
XSSFFormulaEvaluator.evaluateAllFormulaCells(wb);
FileOutputStream fout = new
FileOutputStream("updated_excel_with_formula.xlsx");
//with this call I get the OutOfMemoryException
wb.write(fout);
Is there a way to update my formula and save the workbook?
Can I do it similiar to the Big Grid Demo?
Or can I trigger a update of all formulas, the next time excel starts?
If I start excel, and press STRG+ALT+F9, the formulas can be applied with
the new data.
Thanks,
Lamine
