Excel.Interfaces.RangeAreasLoadOptions interface

RangeAreas 表示同一工作表中的一个或多个矩形区域的集合。RangeAreas represents a collection of one or more rectangular ranges in the same worksheet.

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

属性

$all
address

返回 A1 样式中的 RageAreas 引用。Returns the RageAreas reference in A1-style. 地址值将包含单元格的每个矩形块的工作表名称(例如“Sheet1!A1:B4, Sheet1!D1:D4”)。Address value will contain the worksheet name for each rectangular block of cells (e.g. "Sheet1!A1:B4, Sheet1!D1:D4"). 只读。Read-only.

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

addressLocal

返回用户区域设置中的 RageAreas 引用。Returns the RageAreas reference in the user locale. 只读。Read-only.

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

areaCount

返回包含此 RangeAreas 对象的矩形区域的数量。Returns the number of rectangular ranges that comprise this RangeAreas object.

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

cellCount

返回 RangeAreas 对象中的单元格数量,即总计各个矩形区域的单元格计数。Returns the number of cells in the RangeAreas object, summing up the cell counts of all of the individual rectangular ranges. 如果单元格计数超过 2^31-1 (2,147,483,647),则返回 -1。Returns -1 if the cell count exceeds 2^31-1 (2,147,483,647). 只读。Read-only.

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

dataValidation

返回 RangeAreas 中的所有区域的 dataValidation 对象。Returns a dataValidation object for all ranges in the RangeAreas.

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

format

返回一个 rangeFormat 对象,其中封装了 RangeAreas 对象中的所有区域的字体、填充、边框、对齐方式和其他属性。Returns a rangeFormat object, encapsulating the the font, fill, borders, alignment, and other properties for all ranges in the RangeAreas object.

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

isEntireColumn

指示此 RangeAreas 对象上的所有区域是否表示整列(例如“A:C, Q:Z”)。Indicates whether all the ranges on this RangeAreas object represent entire columns (e.g., "A:C, Q:Z"). 只读。Read-only.

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

isEntireRow

指示此 RangeAreas 对象上的所有区域是否表示整行(例如“1:3, 5:7”)。Indicates whether all the ranges on this RangeAreas object represent entire rows (e.g., "1:3, 5:7"). 只读。Read-only.

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

style

表示此 RangeAreas 对象中的所有区域的样式。Represents the style for all ranges in this RangeAreas object. 如果单元格的样式不一致, 则将返回 null。If the styles of the cells are inconsistent, null will be returned. 对于自定义样式, 将返回样式名称。For custom styles, the style name will be returned. 对于内置样式, 将返回一个表示 BuiltInStyle 枚举中的值的字符串。For built-in styles, a string representing a value in the BuiltInStyle enum will be returned.

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

worksheet

返回当前 RangeAreas 的工作表。Returns the worksheet for the current RangeAreas.

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

属性详细信息

$all

$all?: boolean;

属性值

boolean

address

返回 A1 样式中的 RageAreas 引用。Returns the RageAreas reference in A1-style. 地址值将包含单元格的每个矩形块的工作表名称(例如“Sheet1!A1:B4, Sheet1!D1:D4”)。Address value will contain the worksheet name for each rectangular block of cells (e.g. "Sheet1!A1:B4, Sheet1!D1:D4"). 只读。Read-only.

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

address?: boolean;

属性值

boolean

addressLocal

返回用户区域设置中的 RageAreas 引用。Returns the RageAreas reference in the user locale. 只读。Read-only.

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

addressLocal?: boolean;

属性值

boolean

areaCount

返回包含此 RangeAreas 对象的矩形区域的数量。Returns the number of rectangular ranges that comprise this RangeAreas object.

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

areaCount?: boolean;

属性值

boolean

cellCount

返回 RangeAreas 对象中的单元格数量,即总计各个矩形区域的单元格计数。Returns the number of cells in the RangeAreas object, summing up the cell counts of all of the individual rectangular ranges. 如果单元格计数超过 2^31-1 (2,147,483,647),则返回 -1。Returns -1 if the cell count exceeds 2^31-1 (2,147,483,647). 只读。Read-only.

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

cellCount?: boolean;

属性值

boolean

dataValidation

返回 RangeAreas 中的所有区域的 dataValidation 对象。Returns a dataValidation object for all ranges in the RangeAreas.

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

dataValidation?: Excel.Interfaces.DataValidationLoadOptions;

属性值

format

返回一个 rangeFormat 对象,其中封装了 RangeAreas 对象中的所有区域的字体、填充、边框、对齐方式和其他属性。Returns a rangeFormat object, encapsulating the the font, fill, borders, alignment, and other properties for all ranges in the RangeAreas object.

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

format?: Excel.Interfaces.RangeFormatLoadOptions;

属性值

isEntireColumn

指示此 RangeAreas 对象上的所有区域是否表示整列(例如“A:C, Q:Z”)。Indicates whether all the ranges on this RangeAreas object represent entire columns (e.g., "A:C, Q:Z"). 只读。Read-only.

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

isEntireColumn?: boolean;

属性值

boolean

isEntireRow

指示此 RangeAreas 对象上的所有区域是否表示整行(例如“1:3, 5:7”)。Indicates whether all the ranges on this RangeAreas object represent entire rows (e.g., "1:3, 5:7"). 只读。Read-only.

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

isEntireRow?: boolean;

属性值

boolean

style

表示此 RangeAreas 对象中的所有区域的样式。Represents the style for all ranges in this RangeAreas object. 如果单元格的样式不一致, 则将返回 null。If the styles of the cells are inconsistent, null will be returned. 对于自定义样式, 将返回样式名称。For custom styles, the style name will be returned. 对于内置样式, 将返回一个表示 BuiltInStyle 枚举中的值的字符串。For built-in styles, a string representing a value in the BuiltInStyle enum will be returned.

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

style?: boolean;

属性值

boolean

worksheet

返回当前 RangeAreas 的工作表。Returns the worksheet for the current RangeAreas.

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

worksheet?: Excel.Interfaces.WorksheetLoadOptions;

属性值