Excel.Interfaces.RangeUpdateData interface
An interface for updating data on the Range object, for use in range.set({ ... }).
Properties
| format | Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties. |
| formulas | Represents the formula in A1-style notation. If a cell has no formula, its value is returned instead. |
| formulas |
Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German. If a cell has no formula, its value is returned instead. |
| number |
Represents Excel's number format code for the given range. For more information about Excel number formatting, see Number format codes. |
| values | Represents the raw values of the specified range. The data returned could be a string, number, or Boolean. Cells that contain an error will return the error string. If the returned value starts with a plus ("+"), minus ("-"), or equal sign ("="), Excel interprets this value as a formula. |
Property Details
format
Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties.
format?: Excel.Interfaces.RangeFormatUpdateData;Property Value
Remarks
formulas
Represents the formula in A1-style notation. If a cell has no formula, its value is returned instead.
formulas?: any[][];Property Value
any[][]
Remarks
formulasLocal
Represents the formula in A1-style notation, in the user's language and number-formatting locale. For example, the English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German. If a cell has no formula, its value is returned instead.
formulasLocal?: any[][];Property Value
any[][]
Remarks
numberFormat
Represents Excel's number format code for the given range. For more information about Excel number formatting, see Number format codes.
numberFormat?: any[][];Property Value
any[][]
Remarks
values
Represents the raw values of the specified range. The data returned could be a string, number, or Boolean. Cells that contain an error will return the error string. If the returned value starts with a plus ("+"), minus ("-"), or equal sign ("="), Excel interprets this value as a formula.
values?: any[][];Property Value
any[][]