Excel.Interfaces.RangeFormatLoadOptions interface
A format object encapsulating the range's font, fill, borders, alignment, and other properties.
Remarks
Properties
| $all | Specifying |
| 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. |
| horizontal |
Represents the horizontal alignment for the specified object. See |
| vertical |
Represents the vertical alignment for the specified object. See |
| wrap |
Specifies if Excel wraps the text in the object. A |
Property Details
$all
Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
$all?: boolean;Property Value
boolean
borders
Collection of border objects that apply to the overall range.
borders?: Excel.Interfaces.RangeBorderCollectionLoadOptions;Property Value
Remarks
fill
Returns the fill object defined on the overall range.
fill?: Excel.Interfaces.RangeFillLoadOptions;Property Value
Remarks
font
Returns the font object defined on the overall range.
font?: Excel.Interfaces.RangeFontLoadOptions;Property Value
Remarks
horizontalAlignment
Represents the horizontal alignment for the specified object. See Excel.HorizontalAlignment for details.
horizontalAlignment?: boolean;Property Value
boolean
Remarks
verticalAlignment
Represents the vertical alignment for the specified object. See Excel.VerticalAlignment for details.
verticalAlignment?: boolean;Property Value
boolean
Remarks
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