Hi,
Below code is giving error on calculate method with attached sample file.
using (ExcelEngine excelEngine = new ExcelEngine())
{
IApplication app = excelEngine.Excel;
IWorkbook workbook = app.Workbooks.Open("CTCSampleFile.xlsx", ExcelOpenType.Automatic);
IWorksheet worksheet = workbook.Worksheets["1"];
worksheet.Range["B1"].Value = "24000";
worksheet.Calculate();
workbook.Save();
workbook.Close();
}
Attachment:
CTCSampleFile_bb15c266.zip