Package | Description |
---|---|
com.google.api.services.sheets.v4.model |
Modifier and Type | Method and Description |
---|---|
PivotTable |
PivotTable.clone() |
PivotTable |
CellData.getPivotTable()
A pivot table anchored at this cell.
|
PivotTable |
PivotTable.set(String fieldName,
Object value) |
PivotTable |
PivotTable.setColumns(List<PivotGroup> columns)
Each column grouping in the pivot table.
|
PivotTable |
PivotTable.setCriteria(Map<String,PivotFilterCriteria> criteria)
An optional mapping of filters per source column offset.
|
PivotTable |
PivotTable.setDataExecutionStatus(DataExecutionStatus dataExecutionStatus)
Output only.
|
PivotTable |
PivotTable.setDataSourceId(String dataSourceId)
The ID of the data source the pivot table is reading data from.
|
PivotTable |
PivotTable.setFilterSpecs(List<PivotFilterSpec> filterSpecs)
The filters applied to the source columns before aggregating data for the pivot table.
|
PivotTable |
PivotTable.setRows(List<PivotGroup> rows)
Each row grouping in the pivot table.
|
PivotTable |
PivotTable.setSource(GridRange source)
The range the pivot table is reading data from.
|
PivotTable |
PivotTable.setValueLayout(String valueLayout)
Whether values should be listed horizontally (as columns) or vertically (as rows).
|
PivotTable |
PivotTable.setValues(List<PivotValue> values)
A list of values to include in the pivot table.
|
Modifier and Type | Method and Description |
---|---|
CellData |
CellData.setPivotTable(PivotTable pivotTable)
A pivot table anchored at this cell.
|
Copyright © 2011–2024 Google. All rights reserved.