public void EvaluateAll()
{
HSSFFormulaEvaluator.EvaluateAllFormulaCells(workbook, this);
}
/**
* Coordinates several formula evaluators together so that formulas that involve external
* references can be evaluated.
* @param workbookNames the simple file names used to identify the workbooks in formulas
* with external links (for example "MyData.xls" as used in a formula "[MyData.xls]Sheet1!A1")
* @param evaluators all evaluators for the full set of workbooks required by the formulas.
*/
public static void SetupEnvironment(String[] workbookNames, HSSFFormulaEvaluator[] evaluators)
{
WorkbookEvaluator[] wbEvals = new WorkbookEvaluator[evaluators.Length];
for (int i = 0; i < wbEvals.Length; i++)
{
wbEvals[i] = evaluators[i]._bookEvaluator;
}
CollaboratingWorkbooksEnvironment.Setup(workbookNames, wbEvals);
}