Track changes on workbook in excel

[vishakha.vats]

While working with Excel workbook VSTO appliation using VS2019 and MS Office 2016.
How can we fetch highlighted cells in the worksheet which have been recently updated in the sheet?

[rachel.lei]

Hello,

Thanks for your inquiry.
Sorry at present our Spire.XLS doesn't support tracking changes on workbooks. However, we have added it as a new feature to our further upgrade list with the ticket SPIREXLS-1571. If it can be achieved in the future, we will let you know.

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hello,

Thanks for your patience.
Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:10.11.2 that supports tracking changes on workbooks. Welcome to download it from the following links.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
NuGet link: https://www.nuget.org/packages/Spire.XLS/10.11.2

Code example:

Code: Select all

//Accept all tracked changes
Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
workbook.AcceptAllTrackedChanges();
workbook.SaveToFile(outputFile, FileFormat.Version2013);
//Reject all tracked changes
Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
workbook.RejectAllTrackedChanges();
workbook.SaveToFile(outputFile, FileFormat.Version2013);

Sincerely,
Rachel
E-iceblue support team

[rachel.lei]

Hello,

Greetings from E-iceblue!
Have you tested the new feature? Looking forward to your feedback.

Sincerely,
Rachel
E-iceblue support team