Excel.Interfaces.ConditionalRangeFormatLoadOptions interface

将条件格式区域的字体、填充、边框和其他属性封装在一起的格式对象。A format object encapsulating the conditional formats range's font, fill, borders, and other properties.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

属性

$all
borders

应用于整体条件格式范围的 border 对象的集合。Collection of border objects that apply to the overall conditional format range.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

fill

返回在整体条件格式范围上定义的 fill 对象。Returns the fill object defined on the overall conditional format range.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

font

返回在整体条件格式区域上定义的 font 对象。Returns the font object defined on the overall conditional format range.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

numberFormat

表示给定范围的 Excel 数字格式代码。Represents Excel's number format code for the given range. 如果传入 null, 则清除。Cleared if null is passed in.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

borders

应用于整体条件格式范围的 border 对象的集合。Collection of border objects that apply to the overall conditional format range.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

borders?: Excel.Interfaces.ConditionalRangeBorderCollectionLoadOptions;

属性值

fill

返回在整体条件格式范围上定义的 fill 对象。Returns the fill object defined on the overall conditional format range.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

fill?: Excel.Interfaces.ConditionalRangeFillLoadOptions;

属性值

font

返回在整体条件格式区域上定义的 font 对象。Returns the font object defined on the overall conditional format range.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

font?: Excel.Interfaces.ConditionalRangeFontLoadOptions;

属性值

numberFormat

表示给定范围的 Excel 数字格式代码。Represents Excel's number format code for the given range. 如果传入 null, 则清除。Cleared if null is passed in.

[API 集: ExcelApi 1.6][ API set: ExcelApi 1.6 ]

numberFormat?: boolean;

属性值

boolean