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