Excel.Subtotals interface

数据透视字段的分类汇总。Subtotals for the Pivot Field.

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

属性

automatic

如果将“Automatic”设为 true,则在设置 Subtotals 时,所有其他值均会被忽略。If Automatic is set to true, then all other values will be ignored when setting the Subtotals.

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

average
count
countNumbers
max
min
product
standardDeviation
standardDeviationP
sum
variance
varianceP

属性详细信息

automatic

如果将“Automatic”设为 true,则在设置 Subtotals 时,所有其他值均会被忽略。If Automatic is set to true, then all other values will be ignored when setting the Subtotals.

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

automatic?: boolean;

属性值

boolean

average

average?: boolean;

属性值

boolean

count

count?: boolean;

属性值

boolean

countNumbers

countNumbers?: boolean;

属性值

boolean

max

max?: boolean;

属性值

boolean

min

min?: boolean;

属性值

boolean

product

product?: boolean;

属性值

boolean

standardDeviation

standardDeviation?: boolean;

属性值

boolean

standardDeviationP

standardDeviationP?: boolean;

属性值

boolean

sum

sum?: boolean;

属性值

boolean

variance

variance?: boolean;

属性值

boolean

varianceP

varianceP?: boolean;

属性值

boolean