Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Mon Dec 30, 2013 2:13 pm

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 ?

bradjeng
 
Posts: 1
Joined: Mon Dec 30, 2013 2:07 pm

Tue Dec 31, 2013 2:47 am

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
User avatar

Leaf Weng
 
Posts: 3
Joined: Thu Dec 19, 2013 3:40 am

Tue Jan 07, 2014 9:16 am

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
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Return to Spire.XLS