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

[フレーム] src="bundle.js"> ## 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. // Create a new workbook Workbook workbook = new Workbook();null // Save to an excel file workbook.save("FolderExample.xlsx"); // Create a new workbook var workbook = Workbook() FIXME: No Kotlin code in this demo. // Save to an excel file workbook.save("FolderExample.xlsx")