Excel.Interfaces.RangeFormatLoadOptions interface

一个格式对象,其中封装了区域的字体、填充、边框、对齐方式和其他属性。A format object encapsulating the range's font, fill, borders, alignment, and other properties.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

属性

$all
autoIndent

指示将文本对齐方式设为相等分布时文本是否会自动缩进。Indicates if text is automatically indented when text alignment is set to equal distribution.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

borders

应用于整个区域的 Border 对象的集合。Collection of border objects that apply to the overall range.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

columnWidth

获取或设置区域内的所有列的宽度。Gets or sets the width of all colums within the range. 如果列宽不统一,则返回 NULL。If the column widths are not uniform, null will be returned.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

fill

返回在整个区域内定义的 fill 对象。Returns the fill object defined on the overall range.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

font

返回在整个区域内定义的 Font 对象。Returns the font object defined on the overall range.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

horizontalAlignment

表示指定对象的水平对齐方式。Represents the horizontal alignment for the specified object. 有关详细信息, 请参阅 HorizontalAlignment。See Excel.HorizontalAlignment for details.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

indentLevel

0 到 250 之间的一个整数,指示缩进水平。An integer from 0 to 250 that indicates the indent level.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

protection

返回某一区域的格式 protection 对象。Returns the format protection object for a range.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

readingOrder

区域的读取顺序。The reading order for the range.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

rowHeight

获取或设置区域中所有行的高度。Gets or sets the height of all rows in the range. 如果行高不一致, 则将返回 null。If the row heights are not uniform, null will be returned.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

shrinkToFit

指示文本是否自动缩小以适合可用列宽。Indicates if text automatically shrinks to fit in the available column width.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

textOrientation

获取或设置区域内的所有单元格的文本方向。Gets or sets the text orientation of all the cells within the range. 文本方向应为-90 到90之间的整数, 或者为180垂直方向的文本。The text orientation should be an integer either from -90 to 90, or 180 for vertically-oriented text. 如果区域中的方向不一致, 则将返回 null。If the orientation within a range are not uniform, then null will be returned.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

useStandardHeight

确定 Range 对象的行高是否等于工作表的标准行高。Determines if the row height of the Range object equals the standard height of the sheet. 如果 Range 对象的行高等于工作表的标准高度, 则返回 True。Returns True if the row height of the Range object equals the standard height of the sheet. 如果区域包含多行, 并且行不是都具有相同的高度, 则返回 Null。Returns Null if the range contains more than one row and the rows aren't all the same height. 否则返回 False。Returns False otherwise.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

useStandardWidth

指示 Range 对象的列宽是否等于工作表的标准宽度。Indicates whether the column width of the Range object equals the standard width of the sheet. 如果 Range 对象的列宽等于工作表的标准宽度, 则返回 True。Returns True if the column width of the Range object equals the standard width of the sheet. 如果区域中包含多个列, 并且各列的高度不相同, 则返回 Null。Returns Null if the range contains more than one column and the columns aren't all the same height. 否则返回 False。Returns False otherwise.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

verticalAlignment

表示指定对象的垂直对齐方式。Represents the vertical alignment for the specified object. 有关详细信息, 请参阅 VerticalAlignment。See Excel.VerticalAlignment for details.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

wrapText

指示 Excel 是否将对象中的文本换行。Indicates if Excel wraps the text in the object. 指示整个区域不具有统一换行设置的空值A null value indicates that the entire range doesn't have uniform wrap setting

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

autoIndent

指示将文本对齐方式设为相等分布时文本是否会自动缩进。Indicates if text is automatically indented when text alignment is set to equal distribution.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

autoIndent?: boolean;

属性值

boolean

borders

应用于整个区域的 Border 对象的集合。Collection of border objects that apply to the overall range.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

borders?: Excel.Interfaces.RangeBorderCollectionLoadOptions;

属性值

columnWidth

获取或设置区域内的所有列的宽度。Gets or sets the width of all colums within the range. 如果列宽不统一,则返回 NULL。If the column widths are not uniform, null will be returned.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

columnWidth?: boolean;

属性值

boolean

fill

返回在整个区域内定义的 fill 对象。Returns the fill object defined on the overall range.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

fill?: Excel.Interfaces.RangeFillLoadOptions;

属性值

font

返回在整个区域内定义的 Font 对象。Returns the font object defined on the overall range.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

font?: Excel.Interfaces.RangeFontLoadOptions;

属性值

horizontalAlignment

表示指定对象的水平对齐方式。Represents the horizontal alignment for the specified object. 有关详细信息, 请参阅 HorizontalAlignment。See Excel.HorizontalAlignment for details.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

horizontalAlignment?: boolean;

属性值

boolean

indentLevel

0 到 250 之间的一个整数,指示缩进水平。An integer from 0 to 250 that indicates the indent level.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

indentLevel?: boolean;

属性值

boolean

protection

返回某一区域的格式 protection 对象。Returns the format protection object for a range.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

protection?: Excel.Interfaces.FormatProtectionLoadOptions;

属性值

readingOrder

区域的读取顺序。The reading order for the range.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

readingOrder?: boolean;

属性值

boolean

rowHeight

获取或设置区域中所有行的高度。Gets or sets the height of all rows in the range. 如果行高不一致, 则将返回 null。If the row heights are not uniform, null will be returned.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

rowHeight?: boolean;

属性值

boolean

shrinkToFit

指示文本是否自动缩小以适合可用列宽。Indicates if text automatically shrinks to fit in the available column width.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

shrinkToFit?: boolean;

属性值

boolean

textOrientation

获取或设置区域内的所有单元格的文本方向。Gets or sets the text orientation of all the cells within the range. 文本方向应为-90 到90之间的整数, 或者为180垂直方向的文本。The text orientation should be an integer either from -90 to 90, or 180 for vertically-oriented text. 如果区域中的方向不一致, 则将返回 null。If the orientation within a range are not uniform, then null will be returned.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

textOrientation?: boolean;

属性值

boolean

useStandardHeight

确定 Range 对象的行高是否等于工作表的标准行高。Determines if the row height of the Range object equals the standard height of the sheet. 如果 Range 对象的行高等于工作表的标准高度, 则返回 True。Returns True if the row height of the Range object equals the standard height of the sheet. 如果区域包含多行, 并且行不是都具有相同的高度, 则返回 Null。Returns Null if the range contains more than one row and the rows aren't all the same height. 否则返回 False。Returns False otherwise.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

useStandardHeight?: boolean;

属性值

boolean

useStandardWidth

指示 Range 对象的列宽是否等于工作表的标准宽度。Indicates whether the column width of the Range object equals the standard width of the sheet. 如果 Range 对象的列宽等于工作表的标准宽度, 则返回 True。Returns True if the column width of the Range object equals the standard width of the sheet. 如果区域中包含多个列, 并且各列的高度不相同, 则返回 Null。Returns Null if the range contains more than one column and the columns aren't all the same height. 否则返回 False。Returns False otherwise.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

useStandardWidth?: boolean;

属性值

boolean

verticalAlignment

表示指定对象的垂直对齐方式。Represents the vertical alignment for the specified object. 有关详细信息, 请参阅 VerticalAlignment。See Excel.VerticalAlignment for details.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

verticalAlignment?: boolean;

属性值

boolean

wrapText

指示 Excel 是否将对象中的文本换行。Indicates if Excel wraps the text in the object. 指示整个区域不具有统一换行设置的空值A null value indicates that the entire range doesn't have uniform wrap setting

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

wrapText?: boolean;

属性值

boolean