//Createan ExcelApplication object
ExcelApplication xla = new ExcelApplication();
//Open a workbook containing formulas
Workbook wb = xla.Open("FormulasWorkbook.xlsx);
//Call CalculateFormulas
wb.CalculateFormulas();
Code Block
title
VB
language
vb
'Create an ExcelApplication object
Dim xla As New ExcelApplication
'Open a workbook containing formulas
Dim wb As Workbook = xla.Open("formulasWorkbook.xlsx")
'Call Calculateformulas
wb.CalculateFormulas()