//Create an ExcelApplication object
ExcelApplication xla = new ExcelApplication();
//Open a workbook containing formulas
Workbook wb = xla.Open("FormulasWorkbook.xlsx);
// Create an area
Area a= wb[0].CreateArea("=A1:C4");
//Call CalculateFormulas
a.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")
'Create an area
Dim a as Area= wb[0].CreateArea("=A1:C4")
'Call Calculateformulas
wb.CalculateFormulas()
