Excel.Interfaces.RangeFormatUpdateData interface

Package:

excel

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

Properties

borders	Collection of border objects that apply to the overall range.
fill	Returns the fill object defined on the overall range.
font	Returns the font object defined on the overall range.
horizontalAlignment	Represents the horizontal alignment for the specified object. See Excel.HorizontalAlignment for details.
verticalAlignment	Represents the vertical alignment for the specified object. See Excel.VerticalAlignment for details.
wrapText	Specifies if Excel wraps the text in the object. A null value indicates that the entire range doesn't have a uniform wrap setting

Property Details

borders

Collection of border objects that apply to the overall range.

borders?: Excel.Interfaces.RangeBorderCollectionUpdateData;

Property Value

Excel.Interfaces.RangeBorderCollectionUpdateData

Remarks

[ API set: ExcelApi 1.1 ]

fill

Returns the fill object defined on the overall range.

fill?: Excel.Interfaces.RangeFillUpdateData;

Property Value

Excel.Interfaces.RangeFillUpdateData

Remarks

[ API set: ExcelApi 1.1 ]

font

Returns the font object defined on the overall range.

font?: Excel.Interfaces.RangeFontUpdateData;

Property Value

Excel.Interfaces.RangeFontUpdateData

Remarks

[ API set: ExcelApi 1.1 ]

horizontalAlignment

Represents the horizontal alignment for the specified object. See Excel.HorizontalAlignment for details.

horizontalAlignment?: Excel.HorizontalAlignment | "General" | "Left" | "Center" | "Right" | "Fill" | "Justify" | "CenterAcrossSelection" | "Distributed";

Property Value

Excel.HorizontalAlignment | "General" | "Left" | "Center" | "Right" | "Fill" | "Justify" | "CenterAcrossSelection" | "Distributed"

Remarks

[ API set: ExcelApi 1.1 ]

verticalAlignment

Represents the vertical alignment for the specified object. See Excel.VerticalAlignment for details.

verticalAlignment?: Excel.VerticalAlignment | "Top" | "Center" | "Bottom" | "Justify" | "Distributed";

Property Value

Excel.VerticalAlignment | "Top" | "Center" | "Bottom" | "Justify" | "Distributed"

Remarks

[ API set: ExcelApi 1.1 ]

wrapText

Specifies if Excel wraps the text in the object. A null value indicates that the entire range doesn't have a uniform wrap setting

wrapText?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]