Syncfusion.XlsIO.Base
Example 


Calculate Method

Calculate all the formulas in worksheet.
Syntax
'Declaration
 
Sub Calculate() 
'Usage
 
Dim instance As IWorksheet
 
instance.Calculate()
void Calculate()
Example
The following code illustrates how to calculate all the formulas in the worksheet.
using Syncfusion.XlsIO;
 
 class Example
 {
   static void Main()
   {
     ExcelEngine excelEngine = new ExcelEngine();
     IApplication application = excelEngine.Excel;
     application.DefaultVersion = ExcelVersion.Excel2013;
     IWorkbook workbook = application.Workbooks.Open("Formulas.xlsx");
     IWorksheet worksheet = workbook.Worksheets[0];
     
     // Calculate all the formulas in the worksheet.
     worksheet.Calculate();
            
     workbook.SaveAs("Calculation.xlsx");
     workbook.Close();
     excelEngine.Dispose();
   }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also