Excel Calculation

Excel calculation and setting calculation mode

This project shows how to use Excel application's calculation mode and calculate methods in Excel for web using Office Scripts.

Video

Scenario

Excel for web file's calculation mode can be controlled programatically using simple APIs. Following actions are possible using Office Scripts:

1. Get calculation mode (automatic or manual, etc.)
2. Set the calculation mode
3. Calculate Exel formulas for files that are set to the manual mode (also referred as re-calculate)

Checkout the script and video for more details.

Input Excel file

Any Excel file on the web will do. Checkout the video.

Office Scripts

The solution uses two Office Scripts.

1. Manage Excel calculation and calculation mode options