Excel.Interfaces.DataBarConditionalFormatUpdateData interface

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

属性

axisColor

代表#RRGGBB (例如 "FFA500") 或命名的 HTML 颜色 (例如 "橙色") 的轴线的颜色的 HTML 颜色代码。HTML color code representing the color of the Axis line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange"). "" (空字符串) 如果不存在或未设置轴。"" (empty string) if no axis is present or set.

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

axisFormat

为 Excel 数据栏确定轴的方式的表示形式。Representation of how the axis is determined for an Excel data bar.

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

barDirection

表示数据条图形应基于的方向。Represents the direction that the data bar graphic should be based on.

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

lowerBoundRule

构成数据栏的下限(以及如何计算,如果适用)的规则。The rule for what consistutes the lower bound (and how to calculate it, if applicable) for a data bar.

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

negativeFormat

在 Excel 数据栏中的轴左侧的所有值的表示形式。Representation of all values to the left of the axis in an Excel data bar.

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

positiveFormat

在 Excel 数据栏中的轴右侧的所有值的表示形式。Representation of all values to the right of the axis in an Excel data bar.

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

showDataBarOnly

如果为 true,则对应用数据栏的单元格隐藏值。If true, hides the values from the cells where the data bar is applied.

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

upperBoundRule

构成数据栏的上限(以及如何计算,如果适用)的规则。The rule for what constitutes the upper bound (and how to calculate it, if applicable) for a data bar.

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

属性详细信息

axisColor

代表#RRGGBB (例如 "FFA500") 或命名的 HTML 颜色 (例如 "橙色") 的轴线的颜色的 HTML 颜色代码。HTML color code representing the color of the Axis line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange"). "" (空字符串) 如果不存在或未设置轴。"" (empty string) if no axis is present or set.

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

axisColor?: string;

属性值

string

axisFormat

为 Excel 数据栏确定轴的方式的表示形式。Representation of how the axis is determined for an Excel data bar.

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

axisFormat?: Excel.ConditionalDataBarAxisFormat | "Automatic" | "None" | "CellMidPoint";

属性值

Excel.ConditionalDataBarAxisFormat | "Automatic" | "None" | "CellMidPoint"

barDirection

表示数据条图形应基于的方向。Represents the direction that the data bar graphic should be based on.

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

barDirection?: Excel.ConditionalDataBarDirection | "Context" | "LeftToRight" | "RightToLeft";

属性值

Excel.ConditionalDataBarDirection | "Context" | "LeftToRight" | "RightToLeft"

lowerBoundRule

构成数据栏的下限(以及如何计算,如果适用)的规则。The rule for what consistutes the lower bound (and how to calculate it, if applicable) for a data bar.

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

lowerBoundRule?: Excel.ConditionalDataBarRule;

属性值

negativeFormat

在 Excel 数据栏中的轴左侧的所有值的表示形式。Representation of all values to the left of the axis in an Excel data bar.

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

negativeFormat?: Excel.Interfaces.ConditionalDataBarNegativeFormatUpdateData;

属性值

positiveFormat

在 Excel 数据栏中的轴右侧的所有值的表示形式。Representation of all values to the right of the axis in an Excel data bar.

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

positiveFormat?: Excel.Interfaces.ConditionalDataBarPositiveFormatUpdateData;

属性值

showDataBarOnly

如果为 true,则对应用数据栏的单元格隐藏值。If true, hides the values from the cells where the data bar is applied.

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

showDataBarOnly?: boolean;

属性值

boolean

upperBoundRule

构成数据栏的上限(以及如何计算,如果适用)的规则。The rule for what constitutes the upper bound (and how to calculate it, if applicable) for a data bar.

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

upperBoundRule?: Excel.ConditionalDataBarRule;

属性值