Package | Description |
---|---|
com.google.api.services.sheets.v4.model |
Modifier and Type | Method and Description |
---|---|
PivotGroup |
PivotGroup.clone() |
PivotGroup |
PivotGroup.set(String fieldName,
Object value) |
PivotGroup |
PivotGroup.setDataSourceColumnReference(DataSourceColumnReference dataSourceColumnReference)
The reference to the data source column this grouping is based on.
|
PivotGroup |
PivotGroup.setGroupLimit(PivotGroupLimit groupLimit)
The count limit on rows or columns to apply to this pivot group.
|
PivotGroup |
PivotGroup.setGroupRule(PivotGroupRule groupRule)
The group rule to apply to this row/column group.
|
PivotGroup |
PivotGroup.setLabel(String label)
The labels to use for the row/column groups which can be customized.
|
PivotGroup |
PivotGroup.setRepeatHeadings(Boolean repeatHeadings)
True if the headings in this pivot group should be repeated.
|
PivotGroup |
PivotGroup.setShowTotals(Boolean showTotals)
True if the pivot table should include the totals for this grouping.
|
PivotGroup |
PivotGroup.setSortOrder(String sortOrder)
The order the values in this group should be sorted.
|
PivotGroup |
PivotGroup.setSourceColumnOffset(Integer sourceColumnOffset)
The column offset of the source range that this grouping is based on.
|
PivotGroup |
PivotGroup.setValueBucket(PivotGroupSortValueBucket valueBucket)
The bucket of the opposite pivot group to sort by.
|
PivotGroup |
PivotGroup.setValueMetadata(List<PivotGroupValueMetadata> valueMetadata)
Metadata about values in the grouping.
|
Modifier and Type | Method and Description |
---|---|
List<PivotGroup> |
PivotTable.getColumns()
Each column grouping in the pivot table.
|
List<PivotGroup> |
PivotTable.getRows()
Each row grouping in the pivot table.
|
Modifier and Type | Method and Description |
---|---|
PivotTable |
PivotTable.setColumns(List<PivotGroup> columns)
Each column grouping in the pivot table.
|
PivotTable |
PivotTable.setRows(List<PivotGroup> rows)
Each row grouping in the pivot table.
|
Copyright © 2011–2024 Google. All rights reserved.