Recaluclate excel

[bradjeng]

After change the cell's value, how can I make the excel to recalculate ?

There is a sample code
sheet.Range["E2"].Value = XXX;
workbook.SaveToFile("EditSheet.xlsx", ExcelVersion.Version2010);
System.Diagnostics.Process.Start("EditSheet.xlsx");

Is that possible to recalculate without save and reload ?

[Leaf Weng]

Hi,
Thanks for your inquiry.
For your question,you could use the method as follows:

Code: Select all

sheet.Range["E2"].Value = XXX;
[b]workbook.CalculateAllValue();[/b]


And if you have any problems,please feel free too contact us.

Best regards
Leaf
E-iceblue support team

[Gary.zhang]

Hello,

Have you tested the method? Has your issue been resolved? Could you please give us some feedback if convenience?

If there are any questions, welcome to get it back to us.

Sincerely,
Gary
E-iceblue support team