Excel.Interfaces.RangeUpdateData interface

用于更新 range 对象上的数据的接口, 可用于 "range. set (An interface for updating data on the Range object, for use in "range.set({ ... })".

属性

columnHidden

表示当前 range 的所有列均已隐藏。Represents if all columns of the current range are hidden.

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

dataValidation

返回数据有效性对象。Returns a data validation object.

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

format

返回一个格式对象,其中封装了区域的字体、填充、边框、对齐方式和其他属性。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 表示法的公式。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 样式表示法的公式,使用用户的语言和数字格式区域设置。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 表示法的公式。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 ]

hyperlink

表示当前区域的超链接。Represents the hyperlink for the current range.

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

numberFormat

表示给定范围的 Excel 数字格式代码。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 中的给定区域的数字格式代码,以用户语言的字符串表示。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 ]

rowHidden

表示当前 range 的所有行均已隐藏。Represents if all rows of the current range are hidden.

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

style

表示当前区域的样式。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 ]

values

表示指定区域的原始值。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 ]

属性详细信息

columnHidden

表示当前 range 的所有列均已隐藏。Represents if all columns of the current range are hidden.

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

columnHidden?: boolean;

属性值

boolean

dataValidation

返回数据有效性对象。Returns a data validation object.

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

dataValidation?: Excel.Interfaces.DataValidationUpdateData;

属性值

format

返回一个格式对象,其中封装了区域的字体、填充、边框、对齐方式和其他属性。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.RangeFormatUpdateData;

属性值

formulas

表示采用 A1 表示法的公式。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?: any[][];

属性值

any[][]

formulasLocal

表示采用 A1 样式表示法的公式,使用用户的语言和数字格式区域设置。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?: any[][];

属性值

any[][]

formulasR1C1

表示采用 R1C1 表示法的公式。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?: any[][];

属性值

any[][]

表示当前区域的超链接。Represents the hyperlink for the current range.

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

hyperlink?: Excel.RangeHyperlink;

属性值

numberFormat

表示给定范围的 Excel 数字格式代码。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?: any[][];

属性值

any[][]

numberFormatLocal

表示 Excel 中的给定区域的数字格式代码,以用户语言的字符串表示。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?: any[][];

属性值

any[][]

rowHidden

表示当前 range 的所有行均已隐藏。Represents if all rows of the current range are hidden.

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

rowHidden?: boolean;

属性值

boolean

style

表示当前区域的样式。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?: string;

属性值

string

values

表示指定区域的原始值。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?: any[][];

属性值

any[][]