On Fri, 5 Dec 2014, negatron wrote:
Hello,I try to evaluate the value of the formulas contained in my Workbook "main.xlsx". In these formulas, I have references to an external xlsx file ("test.xlsx"). When I try to run the method "evaluateAllFormulaCells(wbMain)", I get the error: "Could not resolve external workbook name 'test.xlsx'. Workbook environment has not been set up". So I try to set up the environment like this:
Try looking at the testReferencesToOtherWorkbooks() method in TestXSSFFormulaEvaluation for a good example of doing it https://svn.apache.org/repos/asf/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFFormulaEvaluation.java Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
