Excel.Interfaces.RangeFillData interface

描述通过调用 "rangeFill ()" 返回的数据的接口。An interface describing the data returned by calling "rangeFill.toJSON()".

属性

color

代表#RRGGBB (例如 "FFA500") 或命名的 HTML 颜色 (例如 "橙色") 的边框线条颜色的 HTML 颜色代码。HTML color code representing the color of the border line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange")

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

pattern

获取或设置区域的图案。Gets or sets the pattern of a Range. 有关详细信息,请参阅 Excel.FillPattern。See Excel.FillPattern for details. 不支持 LinearGradient 和 RectangularGradient。LinearGradient and RectangularGradient are not supported. 如果为 null 值, 则表示整个区域没有统一的模式设置。A null value indicates that the entire range doesn't have uniform pattern setting.

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

patternColor

设置表示范围模式的颜色的 HTML 颜色代码, 格式#RRGGBB (例如 "FFA500") 或命名的 HTML 颜色 (例如 "橙色")。Sets HTML color code representing the color of the Range pattern, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange"). 获取表示范围模式的颜色的 HTML 颜色代码, 格式#RRGGBB (例如 "FFA500")。Gets HTML color code representing the color of the Range pattern, of the form #RRGGBB (e.g. "FFA500").

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

patternTintAndShade

返回或设置一个使区域填充的图案颜色变亮或变暗的双精度数值,该值介于 -1(最暗)与 1(最亮)之间,初始颜色为 0。Returns or sets a double that lightens or darkens a pattern color for Range Fill, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. 如果模式 tintAndShades 不一致, 则将返回 null。If the pattern tintAndShades are not uniform, null will be returned.

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

tintAndShade

返回或设置一个使区域填充的颜色变亮或变暗的双精度数值,该值介于 -1(最暗)与 1(最亮)之间,初始颜色为 0。Returns or sets a double that lightens or darkens a color for Range Fill, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. 如果 tintAndShades 不是统一的, 将返回 null。If the tintAndShades are not uniform, null will be returned.

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

属性详细信息

color

代表#RRGGBB (例如 "FFA500") 或命名的 HTML 颜色 (例如 "橙色") 的边框线条颜色的 HTML 颜色代码。HTML color code representing the color of the border line, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange")

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

color?: string;

属性值

string

pattern

获取或设置区域的图案。Gets or sets the pattern of a Range. 有关详细信息,请参阅 Excel.FillPattern。See Excel.FillPattern for details. 不支持 LinearGradient 和 RectangularGradient。LinearGradient and RectangularGradient are not supported. 如果为 null 值, 则表示整个区域没有统一的模式设置。A null value indicates that the entire range doesn't have uniform pattern setting.

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

pattern?: Excel.FillPattern | "None" | "Solid" | "Gray50" | "Gray75" | "Gray25" | "Horizontal" | "Vertical" | "Down" | "Up" | "Checker" | "SemiGray75" | "LightHorizontal" | "LightVertical" | "LightDown" | "LightUp" | "Grid" | "CrissCross" | "Gray16" | "Gray8" | "LinearGradient" | "RectangularGradient";

属性值

Excel.FillPattern | "None" | "Solid" | "Gray50" | "Gray75" | "Gray25" | "Horizontal" | "Vertical" | "Down" | "Up" | "Checker" | "SemiGray75" | "LightHorizontal" | "LightVertical" | "LightDown" | "LightUp" | "Grid" | "CrissCross" | "Gray16" | "Gray8" | "LinearGradient" | "RectangularGradient"

patternColor

设置表示范围模式的颜色的 HTML 颜色代码, 格式#RRGGBB (例如 "FFA500") 或命名的 HTML 颜色 (例如 "橙色")。Sets HTML color code representing the color of the Range pattern, of the form #RRGGBB (e.g. "FFA500") or as a named HTML color (e.g. "orange"). 获取表示范围模式的颜色的 HTML 颜色代码, 格式#RRGGBB (例如 "FFA500")。Gets HTML color code representing the color of the Range pattern, of the form #RRGGBB (e.g. "FFA500").

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

patternColor?: string;

属性值

string

patternTintAndShade

返回或设置一个使区域填充的图案颜色变亮或变暗的双精度数值,该值介于 -1(最暗)与 1(最亮)之间,初始颜色为 0。Returns or sets a double that lightens or darkens a pattern color for Range Fill, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. 如果模式 tintAndShades 不一致, 则将返回 null。If the pattern tintAndShades are not uniform, null will be returned.

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

patternTintAndShade?: number;

属性值

number

tintAndShade

返回或设置一个使区域填充的颜色变亮或变暗的双精度数值,该值介于 -1(最暗)与 1(最亮)之间,初始颜色为 0。Returns or sets a double that lightens or darkens a color for Range Fill, the value is between -1 (darkest) and 1 (brightest), with 0 for the original color. 如果 tintAndShades 不是统一的, 将返回 null。If the tintAndShades are not uniform, null will be returned.

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

tintAndShade?: number;

属性值

number