Excel API Library for .NET - Sample Browser | Document Solutions | What-If Analysis

## What-If Analysis What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Document Solutions for Excel provides you two types of What-If Analysis tools: **Goal Seek**, **Scenarios**. - **Goal Seek** is helpful in cases where you have a desired outcome and wish to know the inputs needed to achieve the desired outcome. - A **Scenario** is a set of values that Excel saves and can substitute automatically in cells on a worksheet. It is possible to create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results. // Save to an excel file workbook.Save("FolderExample.xlsx"); ' Create a new Workbook Dim workbook As New Workbook FIXME: This demo doesn't have VB code. ' save to an excel file workbook.Save("FolderExample.xlsx")