Excel.Interfaces.RangeCollectionLoadOptions interface

属性

$all
address

对于集合中的每一项: 代表 A1 样式中的区域引用。For EACH ITEM in the collection: Represents the range reference in A1-style. Address 值将包含工作表引用 (例如, "Sheet1!A1: B4 ")。Address value will contain the Sheet reference (e.g. "Sheet1!A1:B4"). 只读。Read-only.

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

addressLocal

对于集合中的每一项: 代表指定区域的区域引用 (以用户语言表示)。For EACH ITEM in the collection: Represents range reference for the specified range in the language of the user. 只读。Read-only.

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

cellCount

对于集合中的每个项目: 区域中的单元格数量。For EACH ITEM in the collection: Number of cells in the range. 如果单元格数超过 2^31-1 (2,147,483,647),此 API 返回 -1。This API will return -1 if the cell count exceeds 2^31-1 (2,147,483,647). 只读。Read-only.

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

columnCount

对于集合中的每一项: 表示区域中的总列数。For EACH ITEM in the collection: Represents the total number of columns in the range. 只读。Read-only.

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

columnHidden

对于集合中的每一项: 表示是否隐藏当前区域中的所有列。For EACH ITEM in the collection: Represents if all columns of the current range are hidden.

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

columnIndex

对于集合中的每一项: 表示区域中的第一个单元格的列号。For EACH ITEM in the collection: Represents the column number of the first cell in the range. 从零开始编制索引。Zero-indexed. 只读。Read-only.

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

dataValidation

对于集合中的每一项: 返回一个数据验证对象。For EACH ITEM in the collection: Returns a data validation object.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

format

对于集合中的每一项: 返回一个格式对象, 封装区域的字体、填充、边框、对齐方式和其他属性。For EACH ITEM in the collection: Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties.

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

formulas

对于集合中的每一项: 代表 A1 样式表示法中的公式。For EACH ITEM in the collection: Represents the formula in A1-style notation. 将公式设置为区域时, value 参数可以是单个值 (字符串), 也可以是二维数组。When setting formulas to a range, the value argument can be either a single value (a string) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

formulasLocal

对于集合中的每一项: 代表 A1 样式表示法中的公式, 位于用户的语言和数字格式设置区域中。For EACH ITEM in the collection: Represents the formula in A1-style notation, in the user's language and number-formatting locale. 例如,英语中的公式 "=SUM(A1, 1.5)" 在德语中将变为 "=SUMME(A1; 1,5)"。For example, the English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German. 将公式设置为区域时, value 参数可以是单个值 (字符串), 也可以是二维数组。When setting formulas to a range, the value argument can be either a single value (a string) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

formulasR1C1

对于集合中的每一项: 以 R1C1 样式表示法表示的公式。For EACH ITEM in the collection: Represents the formula in R1C1-style notation. 将公式设置为区域时, value 参数可以是单个值 (字符串), 也可以是二维数组。When setting formulas to a range, the value argument can be either a single value (a string) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

hasSpill

对于集合中的每一项: 表示是否所有单元格都有溢出边框。For EACH ITEM in the collection: Represents if all cells have a spill border. 如果所有单元格都有溢出边框, 则返回 true; 如果所有单元格都没有溢出边框, 则返回 false。Returns true if all cells have a spill border, or false if all cells do not have a spill border. 如果区域中有和没有溢出边框的单元格, 则返回 null。Returns null if there are cells both with and without spill borders within the range.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

height

对于集合中的每一项: 返回以磅为单位的距离, 100 以磅为单位, 从区域的上边缘到区域的下边缘之间的距离 (以磅为单位)。For EACH ITEM in the collection: Returns the distance in points, for 100% zoom, from top edge of the range to bottom edge of the range. 只读。Read-only.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

hidden

对于集合中的每一项: 表示是否隐藏当前区域中的所有单元格。For EACH ITEM in the collection: Represents if all cells of the current range are hidden. 只读。Read-only.

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

hyperlink

对于集合中的每一项: 代表当前区域的超链接。For EACH ITEM in the collection: Represents the hyperlink for the current range.

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

isEntireColumn

对于集合中的每一项: 表示当前区域是否为整列。For EACH ITEM in the collection: Represents if the current range is an entire column. 只读。Read-only.

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

isEntireRow

对于集合中的每一项: 表示当前区域是否为整行。For EACH ITEM in the collection: Represents if the current range is an entire row. 只读。Read-only.

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

left

对于集合中的每个项目: 返回以磅为单位的距离, 以磅为单位, 从工作表左边缘到区域左边缘的比例为 100%。For EACH ITEM in the collection: Returns the distance in points, for 100% zoom, from left edge of the worksheet to left edge of the range. 只读。Read-only.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

linkedDataTypeState

对于集合中的每一项: 表示每个单元格的数据类型状态。For EACH ITEM in the collection: Represents the data type state of each cell. 只读。Read-only.

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

numberFormat

对于集合中的每一项: 表示给定范围的 Excel 的编号格式代码。For EACH ITEM in the collection: Represents Excel's number format code for the given range. 将数字格式设置为一个区域时, value 参数可以是单个值 (string), 也可以是二维数组。When setting number format to a range, the value argument can be either a single value (string) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

numberFormatLocal

对于集合中的每一项: 以用户语言的字符串形式表示给定范围的 Excel 数字格式代码。For EACH ITEM in the collection: Represents Excel's number format code for the given range as a string in the language of the user. 将数字格式设置为局部区域时, value 参数可以是单个值 (字符串), 也可以是二维数组。When setting number format local to a range, the value argument can be either a single value (string) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

rowCount

对于集合中的每一项: 返回范围中的总行数。For EACH ITEM in the collection: Returns the total number of rows in the range. 只读。Read-only.

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

rowHidden

对于集合中的每一项: 表示是否隐藏当前区域中的所有行。For EACH ITEM in the collection: Represents if all rows of the current range are hidden.

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

rowIndex

对于集合中的每一项: 返回区域中第一个单元格的行号。For EACH ITEM in the collection: Returns the row number of the first cell in the range. 从零开始编制索引。Zero-indexed. 只读。Read-only.

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

savedAsArray

对于集合中的每一项: 表示是否将所有单元格都保存为数组公式。For EACH ITEM in the collection: Represents if ALL the cells would be saved as an array formula. 如果所有单元格都将保存为数组, 则返回 true; 如果所有单元格不保存为数组公式, 则返回 false。Returns true if ALL cells would be saved as an array, or false if ALL cells would NOT be saved as an array formula. 如果有混合的单元格, 且不能保存为数组公式, 则返回 null。Returns null if there is a mixture of cells that would and would not be saved as an array formula.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

style

对于集合中的每一项: 代表当前区域的样式。For EACH ITEM in the collection: Represents the style of the current range. 如果单元格的样式不一致, 则将返回 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.7][ API set: ExcelApi 1.7 ]

text

对于集合中的每一项: 指定区域的文本值。For EACH ITEM in the collection: Text values of the specified range. 文本值与单元格宽度无关。The Text value will not depend on the cell width. Excel # UI 中发生的符号替换不会影响 API 返回的文本值。The # sign substitution that happens in Excel UI will not affect the text value returned by the API. 只读。Read-only.

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

top

对于集合中的每个项目: 返回以磅为单位的距离, 以磅100为单位, 从工作表的上边缘到区域的上边缘之间的距离 (以磅为单位)。For EACH ITEM in the collection: Returns the distance in points, for 100% zoom, from top edge of the worksheet to top edge of the range. 只读。Read-only.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

values

对于集合中的每一项: 代表指定区域的原始值。For EACH ITEM in the collection: Represents the raw values of the specified range. 返回的数据可能是字符串、数字,也可能是布尔值。The data returned could be of type string, number, or a boolean. 包含错误的单元格将返回错误字符串。Cells that contain an error will return the error string. 将值设置为一个范围时, value 参数可以是单个值 (string、number 或 boolean), 也可以是一个二维数组。When setting values to a range, the value argument can be either a single value (string, number or boolean) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

valueTypes

对于集合中的每一项: 代表每个单元格的数据类型。For EACH ITEM in the collection: Represents the type of data of each cell. 只读。Read-only.

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

width

对于集合中的每个项目: 返回以磅为单位的距离, 以磅为单位, 从区域的左边缘到该范围的右边缘之间的 100% 缩放。For EACH ITEM in the collection: Returns the distance in points, for 100% zoom, from left edge of the range to right edge of the range. 只读。Read-only.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

worksheet

对于集合中的每一项: 包含当前区域的工作表。For EACH ITEM in the collection: The worksheet containing the current range.

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

属性详细信息

$all

$all?: boolean;

属性值

boolean

address

对于集合中的每一项: 代表 A1 样式中的区域引用。For EACH ITEM in the collection: Represents the range reference in A1-style. Address 值将包含工作表引用 (例如, "Sheet1!A1: B4 ")。Address value will contain the Sheet reference (e.g. "Sheet1!A1:B4"). 只读。Read-only.

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

address?: boolean;

属性值

boolean

addressLocal

对于集合中的每一项: 代表指定区域的区域引用 (以用户语言表示)。For EACH ITEM in the collection: Represents range reference for the specified range in the language of the user. 只读。Read-only.

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

addressLocal?: boolean;

属性值

boolean

cellCount

对于集合中的每个项目: 区域中的单元格数量。For EACH ITEM in the collection: Number of cells in the range. 如果单元格数超过 2^31-1 (2,147,483,647),此 API 返回 -1。This API will return -1 if the cell count exceeds 2^31-1 (2,147,483,647). 只读。Read-only.

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

cellCount?: boolean;

属性值

boolean

columnCount

对于集合中的每一项: 表示区域中的总列数。For EACH ITEM in the collection: Represents the total number of columns in the range. 只读。Read-only.

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

columnCount?: boolean;

属性值

boolean

columnHidden

对于集合中的每一项: 表示是否隐藏当前区域中的所有列。For EACH ITEM in the collection: Represents if all columns of the current range are hidden.

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

columnHidden?: boolean;

属性值

boolean

columnIndex

对于集合中的每一项: 表示区域中的第一个单元格的列号。For EACH ITEM in the collection: Represents the column number of the first cell in the range. 从零开始编制索引。Zero-indexed. 只读。Read-only.

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

columnIndex?: boolean;

属性值

boolean

dataValidation

对于集合中的每一项: 返回一个数据验证对象。For EACH ITEM in the collection: Returns a data validation object.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

dataValidation?: Excel.Interfaces.DataValidationLoadOptions;

属性值

format

对于集合中的每一项: 返回一个格式对象, 封装区域的字体、填充、边框、对齐方式和其他属性。For EACH ITEM in the collection: Returns a format object, encapsulating the range's font, fill, borders, alignment, and other properties.

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

format?: Excel.Interfaces.RangeFormatLoadOptions;

属性值

formulas

对于集合中的每一项: 代表 A1 样式表示法中的公式。For EACH ITEM in the collection: Represents the formula in A1-style notation. 将公式设置为区域时, value 参数可以是单个值 (字符串), 也可以是二维数组。When setting formulas to a range, the value argument can be either a single value (a string) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

formulas?: boolean;

属性值

boolean

formulasLocal

对于集合中的每一项: 代表 A1 样式表示法中的公式, 位于用户的语言和数字格式设置区域中。For EACH ITEM in the collection: Represents the formula in A1-style notation, in the user's language and number-formatting locale. 例如,英语中的公式 "=SUM(A1, 1.5)" 在德语中将变为 "=SUMME(A1; 1,5)"。For example, the English "=SUM(A1, 1.5)" formula would become "=SUMME(A1; 1,5)" in German. 将公式设置为区域时, value 参数可以是单个值 (字符串), 也可以是二维数组。When setting formulas to a range, the value argument can be either a single value (a string) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

formulasLocal?: boolean;

属性值

boolean

formulasR1C1

对于集合中的每一项: 以 R1C1 样式表示法表示的公式。For EACH ITEM in the collection: Represents the formula in R1C1-style notation. 将公式设置为区域时, value 参数可以是单个值 (字符串), 也可以是二维数组。When setting formulas to a range, the value argument can be either a single value (a string) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

formulasR1C1?: boolean;

属性值

boolean

hasSpill

备注

此 API 以预览状态提供给开发者,可能根据我们收到的反馈更改。 请勿在生产环境中使用此 API。

对于集合中的每一项: 表示是否所有单元格都有溢出边框。For EACH ITEM in the collection: Represents if all cells have a spill border. 如果所有单元格都有溢出边框, 则返回 true; 如果所有单元格都没有溢出边框, 则返回 false。Returns true if all cells have a spill border, or false if all cells do not have a spill border. 如果区域中有和没有溢出边框的单元格, 则返回 null。Returns null if there are cells both with and without spill borders within the range.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

hasSpill?: boolean;

属性值

boolean

height

备注

此 API 以预览状态提供给开发者,可能根据我们收到的反馈更改。 请勿在生产环境中使用此 API。

对于集合中的每一项: 返回以磅为单位的距离, 100 以磅为单位, 从区域的上边缘到区域的下边缘之间的距离 (以磅为单位)。For EACH ITEM in the collection: Returns the distance in points, for 100% zoom, from top edge of the range to bottom edge of the range. 只读。Read-only.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

height?: boolean;

属性值

boolean

hidden

对于集合中的每一项: 表示是否隐藏当前区域中的所有单元格。For EACH ITEM in the collection: Represents if all cells of the current range are hidden. 只读。Read-only.

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

hidden?: boolean;

属性值

boolean

对于集合中的每一项: 代表当前区域的超链接。For EACH ITEM in the collection: Represents the hyperlink for the current range.

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

hyperlink?: boolean;

属性值

boolean

isEntireColumn

对于集合中的每一项: 表示当前区域是否为整列。For EACH ITEM in the collection: Represents if the current range is an entire column. 只读。Read-only.

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

isEntireColumn?: boolean;

属性值

boolean

isEntireRow

对于集合中的每一项: 表示当前区域是否为整行。For EACH ITEM in the collection: Represents if the current range is an entire row. 只读。Read-only.

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

isEntireRow?: boolean;

属性值

boolean

left

备注

此 API 以预览状态提供给开发者,可能根据我们收到的反馈更改。 请勿在生产环境中使用此 API。

对于集合中的每个项目: 返回以磅为单位的距离, 以磅为单位, 从工作表左边缘到区域左边缘的比例为 100%。For EACH ITEM in the collection: Returns the distance in points, for 100% zoom, from left edge of the worksheet to left edge of the range. 只读。Read-only.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

left?: boolean;

属性值

boolean

linkedDataTypeState

对于集合中的每一项: 表示每个单元格的数据类型状态。For EACH ITEM in the collection: Represents the data type state of each cell. 只读。Read-only.

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

linkedDataTypeState?: boolean;

属性值

boolean

numberFormat

对于集合中的每一项: 表示给定范围的 Excel 的编号格式代码。For EACH ITEM in the collection: Represents Excel's number format code for the given range. 将数字格式设置为一个区域时, value 参数可以是单个值 (string), 也可以是二维数组。When setting number format to a range, the value argument can be either a single value (string) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

numberFormat?: boolean;

属性值

boolean

numberFormatLocal

对于集合中的每一项: 以用户语言的字符串形式表示给定范围的 Excel 数字格式代码。For EACH ITEM in the collection: Represents Excel's number format code for the given range as a string in the language of the user. 将数字格式设置为局部区域时, value 参数可以是单个值 (字符串), 也可以是二维数组。When setting number format local to a range, the value argument can be either a single value (string) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

numberFormatLocal?: boolean;

属性值

boolean

rowCount

对于集合中的每一项: 返回范围中的总行数。For EACH ITEM in the collection: Returns the total number of rows in the range. 只读。Read-only.

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

rowCount?: boolean;

属性值

boolean

rowHidden

对于集合中的每一项: 表示是否隐藏当前区域中的所有行。For EACH ITEM in the collection: Represents if all rows of the current range are hidden.

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

rowHidden?: boolean;

属性值

boolean

rowIndex

对于集合中的每一项: 返回区域中第一个单元格的行号。For EACH ITEM in the collection: Returns the row number of the first cell in the range. 从零开始编制索引。Zero-indexed. 只读。Read-only.

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

rowIndex?: boolean;

属性值

boolean

savedAsArray

备注

此 API 以预览状态提供给开发者,可能根据我们收到的反馈更改。 请勿在生产环境中使用此 API。

对于集合中的每一项: 表示是否将所有单元格都保存为数组公式。For EACH ITEM in the collection: Represents if ALL the cells would be saved as an array formula. 如果所有单元格都将保存为数组, 则返回 true; 如果所有单元格不保存为数组公式, 则返回 false。Returns true if ALL cells would be saved as an array, or false if ALL cells would NOT be saved as an array formula. 如果有混合的单元格, 且不能保存为数组公式, 则返回 null。Returns null if there is a mixture of cells that would and would not be saved as an array formula.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

savedAsArray?: boolean;

属性值

boolean

style

对于集合中的每一项: 代表当前区域的样式。For EACH ITEM in the collection: Represents the style of the current range. 如果单元格的样式不一致, 则将返回 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.7][ API set: ExcelApi 1.7 ]

style?: boolean;

属性值

boolean

text

对于集合中的每一项: 指定区域的文本值。For EACH ITEM in the collection: Text values of the specified range. 文本值与单元格宽度无关。The Text value will not depend on the cell width. Excel # UI 中发生的符号替换不会影响 API 返回的文本值。The # sign substitution that happens in Excel UI will not affect the text value returned by the API. 只读。Read-only.

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

text?: boolean;

属性值

boolean

top

备注

此 API 以预览状态提供给开发者,可能根据我们收到的反馈更改。 请勿在生产环境中使用此 API。

对于集合中的每个项目: 返回以磅为单位的距离, 以磅100为单位, 从工作表的上边缘到区域的上边缘之间的距离 (以磅为单位)。For EACH ITEM in the collection: Returns the distance in points, for 100% zoom, from top edge of the worksheet to top edge of the range. 只读。Read-only.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

top?: boolean;

属性值

boolean

values

对于集合中的每一项: 代表指定区域的原始值。For EACH ITEM in the collection: Represents the raw values of the specified range. 返回的数据可能是字符串、数字,也可能是布尔值。The data returned could be of type string, number, or a boolean. 包含错误的单元格将返回错误字符串。Cells that contain an error will return the error string. 将值设置为一个范围时, value 参数可以是单个值 (string、number 或 boolean), 也可以是一个二维数组。When setting values to a range, the value argument can be either a single value (string, number or boolean) or a two-dimensional array. 如果参数是单个值, 它将应用于区域中的所有单元格。If the argument is a single value, it will be applied to all cells in the range.

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

values?: boolean;

属性值

boolean

valueTypes

对于集合中的每一项: 代表每个单元格的数据类型。For EACH ITEM in the collection: Represents the type of data of each cell. 只读。Read-only.

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

valueTypes?: boolean;

属性值

boolean

width

备注

此 API 以预览状态提供给开发者,可能根据我们收到的反馈更改。 请勿在生产环境中使用此 API。

对于集合中的每个项目: 返回以磅为单位的距离, 以磅为单位, 从区域的左边缘到该范围的右边缘之间的 100% 缩放。For EACH ITEM in the collection: Returns the distance in points, for 100% zoom, from left edge of the range to right edge of the range. 只读。Read-only.

[API 集: EXCELAPI BETA (仅限预览)][ API set: ExcelApi BETA (PREVIEW ONLY) ]

width?: boolean;

属性值

boolean

worksheet

对于集合中的每一项: 包含当前区域的工作表。For EACH ITEM in the collection: The worksheet containing the current range.

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

worksheet?: Excel.Interfaces.WorksheetLoadOptions;

属性值