Excel.Interfaces.ApplicationData interface

An interface describing the data returned by calling "application.toJSON()".

Properties

calculationEngineVersion

Returns the Excel calculation engine version used for the last full recalculation. Read-only.

[ API set: ExcelApi 1.9 ]

calculationMode

Returns the calculation mode used in the workbook, as defined by the constants in Excel.CalculationMode. Possible values are: Automatic, where Excel controls recalculation; AutomaticExceptTables, where Excel controls recalculation but ignores changes in tables; Manual, where calculation is done when the user requests it.

[ API set: ExcelApi 1.1 for get, 1.8 for set ]

calculationState

Returns the calculation state of the application. See Excel.CalculationState for details. Read-only.

[ API set: ExcelApi 1.9 ]

iterativeCalculation

Returns the Iterative Calculation settings. In Excel on Windows and Mac, the settings will apply to the Excel Application. In Excel on the web and other platforms, the settings will apply to the active workbook.

[ API set: ExcelApi 1.9 ]

Property Details

calculationEngineVersion

Returns the Excel calculation engine version used for the last full recalculation. Read-only.

[ API set: ExcelApi 1.9 ]

calculationEngineVersion?: number;

Property Value

number

calculationMode

Returns the calculation mode used in the workbook, as defined by the constants in Excel.CalculationMode. Possible values are: Automatic, where Excel controls recalculation; AutomaticExceptTables, where Excel controls recalculation but ignores changes in tables; Manual, where calculation is done when the user requests it.

[ API set: ExcelApi 1.1 for get, 1.8 for set ]

calculationMode?: Excel.CalculationMode | "Automatic" | "AutomaticExceptTables" | "Manual";

Property Value

Excel.CalculationMode | "Automatic" | "AutomaticExceptTables" | "Manual"

calculationState

Returns the calculation state of the application. See Excel.CalculationState for details. Read-only.

[ API set: ExcelApi 1.9 ]

calculationState?: Excel.CalculationState | "Done" | "Calculating" | "Pending";

Property Value

Excel.CalculationState | "Done" | "Calculating" | "Pending"

iterativeCalculation

Returns the Iterative Calculation settings. In Excel on Windows and Mac, the settings will apply to the Excel Application. In Excel on the web and other platforms, the settings will apply to the active workbook.

[ API set: ExcelApi 1.9 ]

iterativeCalculation?: Excel.Interfaces.IterativeCalculationData;

Property Value