计算工作簿公式

计算工作簿公式

请使用Workbook.CalculateFormula()方法来计算工作簿的公式。以下示例代码解释了此方法的用法。

示例代码

//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C
Aspose::Cells::Startup();
//Create a new workbook
Workbook wb;
//Get first worksheet which is created by default
Worksheet ws = wb.GetWorksheets().Get(0);
//Adding a value to "A1" cell
Cell cell = ws.GetCells().Get(u"A1");
cell.PutValue(5);
//Adding a value to "A2" cell
cell = ws.GetCells().Get(u"A2");
cell.PutValue(15);
//Adding a value to "A3" cell
cell = ws.GetCells().Get(u"A3");
cell.PutValue(25);
//Adding SUM formula to "A4" cell
cell = ws.GetCells().Get(u"A4");
cell.SetFormula(u"=SUM(A1:A3)");
//Calculating the results of formulas
wb.CalculateFormula();
//Get the calculated value of the cell "A4" and print it on console
cell = ws.GetCells().Get(u"A4");
std::cout << "Calculated Value of Cell A4: " << cell.GetStringValue().ToUtf8() << std::endl;
Aspose::Cells::Cleanup();

控制台输出

这是上述示例代码的控制台输出。

 Calculated Value of Cell A4: 45