/// <summary> /// 更新Formula /// </summary> public void UpdateFormula() { var formulaEvaluator = Workbook.GetFormulaEvaluator(); foreach (var sheet in Workbook.AsEnumerable()) { sheet.ForceFormulaRecalculation = true; foreach (var row in sheet.AsEnumerable()) { foreach (var cell in row.AsEnumerable()) { if (cell != null && cell.CellType == CellType.Formula) { formulaEvaluator.EvaluateFormulaCell(cell); } } } } }