application.md

Application

Represents the Excel application that manages the workbook.

Properties

Property	Type	Description
calculationMode	string	Returns the calculation mode used in the workbook. Read-only. Possible values are: Automatic Excel controls recalculation.,AutomaticExceptTables Excel controls recalculation but ignores changes in tables.,Manual Calculation is done when the user requests it.

Relationships

None

Methods

Method	Return Type	Description
calculate(calculationType: string)	void	Recalculate all currently opened workbooks in Excel.
load(param: object)	void	Fills the proxy object created in JavaScript layer with property and object values specified in the parameter.

API Specification

calculate(calculationType: string)

Recalculate all currently opened workbooks in Excel.

Syntax

applicationObject.calculate(calculationType);

Parameters

Parameter	Type	Description
calculationType	string	Specifies the calculation type to use. Possible values are: Recalculate Default-option. Performs normal calculation by calculating all the formulas in the workbook.,Full Forces a full calculation of the data.,FullRebuild Forces a full calculation of the data and rebuilds the dependencies.

Returns

void

Examples

var ctx = new Excel.RequestContext();
ctx.workbook.application.calculate('Full');
ctx.executeAsync();

Back

load(param: object)

Fills the proxy object created in JavaScript layer with property and object values specified in the parameter.

Syntax

object.load(param);

Parameters

Parameter	Type	Description
param	object	Optional. Accepts parameter and relationship names as delimited string or an array. Or, provide loadOption object.

Returns

void

Examples

Back

Getter Examples

var ctx = new Excel.RequestContext();
var application = ctx.workbook.application;
ctx.load(application);
ctx.executeAsync().then(function() {
	Console.log(application.calculationMode);
});

Back