Application

(1.1) Represents the Excel application that manages the workbook.

calculateRecalculate all currently opened workbooks in Excel. Method
calculationEngineVersion(Added in 1.9) Returns the Excel calculation engine version used for the last full recalculation. Property
calculationModeReturns the calculation mode used in the workbook. Property
calculationState(Added in 1.9) Returns the calculation state of the application. Property
contextReturns the request context associated with the object. Property
cultureInfo(Added in 1.11) Returns information based on current system culture settings. Property
decimalSeparator(Added in 1.11) Returns the string used as the decimal separator for numeric values. Property
iterativeCalculation(Added in 1.9) Returns the Iterative Calculation setting. Property
loadQueues up a command to load the specified properties of the object. Method
setSets multiple properties of an object at the same time. Method
suspendApiCalculationUntilNextSync(Added in 1.6) Suspends calculation until the next "context.sync()" is called. Method
suspendScreenUpdatingUntilNextSync(Added in 1.9) Suspends screen updating until the next context.sync() is called. Method
thousandsSeparator(Added in 1.11) Returns the string used to separate groups of digits to the left of the decimal. Property
toJSONOverrides the JavaScript toJSON() method in order to provide more useful output when an API object is passed to JSON.stringify(). Method
useSystemSeparators(Added in 1.11) Returns if the system separators of Excel and are enabled. Property

calculate
Recalculate all currently opened workbooks in Excel. Method
calculationEngineVersion
(Added in 1.9) Returns the Excel calculation engine version used for the last full recalculation. Property
calculationMode
Returns the calculation mode used in the workbook. Property
calculationState
(Added in 1.9) Returns the calculation state of the application. Property
context
Returns the request context associated with the object. Property
cultureInfo
(Added in 1.11) Returns information based on current system culture settings. Property
decimalSeparator
(Added in 1.11) Returns the string used as the decimal separator for numeric values. Property
iterativeCalculation
(Added in 1.9) Returns the Iterative Calculation setting. Property
load
Queues up a command to load the specified properties of the object. Method
set
Sets multiple properties of an object at the same time. Method
suspendApiCalculationUntilNextSync
(Added in 1.6) Suspends calculation until the next "context.sync()" is called. Method
suspendScreenUpdatingUntilNextSync
(Added in 1.9) Suspends screen updating until the next context.sync() is called. Method
thousandsSeparator
(Added in 1.11) Returns the string used to separate groups of digits to the left of the decimal. Property
toJSON
Overrides the JavaScript toJSON() method in order to provide more useful output when an API object is passed to JSON.stringify(). Method
useSystemSeparators
(Added in 1.11) Returns if the system separators of Excel and are enabled. Property

REMARKS
* Added in 1.1
* The ability to set the "calculationMode" was only added in 1.8.
* The "decimalSeparator" and "thousandsSeparator" are based on Excel's local settings.
* For desktop "iterativeCalculation" is an application setting but in Excel on the web this applies to the active workbook.
* You must call context.sync() before reading the properties using "load".
* Do not call suspendScreenUpdatingUntilNextSync repeatedly (such as in a loop). Repeated calls will cause the Excel window to flicker.
* For the Microsoft documentation refer to docs.microsoft.com

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top