Calculer les formules du classeur

Calculer les formules du classeur

Veuillez utiliser la méthode Workbook.CalculateFormula() pour calculer les formules de votre classeur. Le code d’exemple suivant explique l’utilisation de cette méthode.

Code d’exemple

//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();

Sortie console

Il s’agit de la sortie de la console du code d’exemple ci-dessus.

 Calculated Value of Cell A4: 45