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.

Wed Jan 18, 2023 9:06 pm

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

Thank's .David

daviddahan
 
Posts: 1
Joined: Wed Jan 04, 2023 5:55 pm

Thu Jan 19, 2023 2:50 am

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

Abel.He
 
Posts: 860
Joined: Tue Mar 08, 2022 2:02 am

Fri Feb 17, 2023 10:12 am

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

Abel.He
 
Posts: 860
Joined: Tue Mar 08, 2022 2:02 am

Return to Spire.XLS