Edit

Share via

Excel.Interfaces.RangeAreasUpdateData interface

Package:
excel

An interface for updating data on the RangeAreas object, for use in rangeAreas.set({ ... }).

Properties

dataValidation

Returns a data validation object for all ranges in the RangeAreas.
format

Returns a RangeFormat object, encapsulating the font, fill, borders, alignment, and other properties for all ranges in the RangeAreas object.
style

Represents the style for all ranges in this RangeAreas object. If the styles of the cells are inconsistent, null will be returned. For custom styles, the style name will be returned. For built-in styles, a string representing a value in the BuiltInStyle enum will be returned.

Property Details

dataValidation

Returns a data validation object for all ranges in the RangeAreas.

dataValidation?: Excel.Interfaces.DataValidationUpdateData;

Property Value

Excel.Interfaces.DataValidationUpdateData

Remarks

[ API set: ExcelApi 1.9 ]

format

Returns a RangeFormat object, encapsulating the font, fill, borders, alignment, and other properties for all ranges in the RangeAreas object.

format?: Excel.Interfaces.RangeFormatUpdateData;

Property Value

Excel.Interfaces.RangeFormatUpdateData

Remarks

[ API set: ExcelApi 1.9 ]

style

Represents the style for all ranges in this RangeAreas object. If the styles of the cells are inconsistent, null will be returned. For custom styles, the style name will be returned. For built-in styles, a string representing a value in the BuiltInStyle enum will be returned.

style?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.9 ]