Excel.Interfaces.ApplicationLoadOptions interface

Package:

excel

Represents the Excel application that manages the workbook.

Remarks

[ API set: ExcelApi 1.1 ]

Properties

$all	Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).
calculationEngineVersion	Returns the Excel calculation engine version used for the last full recalculation.
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.
calculationState	Returns the calculation state of the application. See Excel.CalculationState for details.
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.

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

calculationEngineVersion

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

calculationEngineVersion?: boolean;

Property Value

boolean

Remarks

[ 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.

calculationMode?: boolean;

Property Value

boolean

Remarks

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

calculationState

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

calculationState?: boolean;

Property Value

boolean

Remarks

[ 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.

iterativeCalculation?: Excel.Interfaces.IterativeCalculationLoadOptions;

Property Value

Excel.Interfaces.IterativeCalculationLoadOptions

Remarks

[ API set: ExcelApi 1.9 ]