what if analysis. is supported in spire.xls c# ?

[daviddahan]

Hello,
I'm new here. i'm wondering if spire.xls support running "what if analysis" goal seek in some way....

Thank's .David

[Abel.He]

Hello,

Thanks for your inquiry.
Sorry for Spire.Xls don’t support currently the function you mentioned, but I have logged it as a new function into our product updating system with the ticket number SPIREXLS-4422. Our development team will achieve it. Once it is achieved, I will inform you in time.

Sincerely
Abel
E-iceblue support team

[Abel.He]

Hello,

Thanks for your patience!
Glad to inform you that we just released Spire.Xls 13.2.4 which achieve the new feature with SPIREXLS-4422.
Please download the new version from the following links to test, and refer to the following code.

Website download link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget download link: https://www.nuget.org/packages/Spire.XLS/13.2.4

Code: Select all

Workbook book = new Workbook();
book.LoadFromFile(inputFile);
Worksheet sheet = book.Worksheets[0];
CellRange targetCell = sheet.Range["E2"];
CellRange gussCell = sheet.Range["B4"];
GoalSeek goalSeek = new GoalSeek();
GoalSeekResult result= goalSeek.TryCalculate (targetCell, 2000, gussCell);
result.Determine();

Sincerely
Abel
E-iceblue support team