public final class PivotTable
extends com.google.api.client.json.GenericJson
This is the Java data model class that specifies how to parse/serialize into the JSON that is transmitted over HTTP when working with the Google Sheets API. For a detailed explanation see: https://developers.google.com/api-client-library/java/google-http-java-client/json
com.google.api.client.util.GenericData.Flags
AbstractMap.SimpleEntry<K,V>, AbstractMap.SimpleImmutableEntry<K,V>
Constructor and Description |
---|
PivotTable() |
Modifier and Type | Method and Description |
---|---|
PivotTable |
clone() |
List<PivotGroup> |
getColumns()
Each column grouping in the pivot table.
|
Map<String,PivotFilterCriteria> |
getCriteria()
An optional mapping of filters per source column offset.
|
DataExecutionStatus |
getDataExecutionStatus()
Output only.
|
String |
getDataSourceId()
The ID of the data source the pivot table is reading data from.
|
List<PivotFilterSpec> |
getFilterSpecs()
The filters applied to the source columns before aggregating data for the pivot table.
|
List<PivotGroup> |
getRows()
Each row grouping in the pivot table.
|
GridRange |
getSource()
The range the pivot table is reading data from.
|
String |
getValueLayout()
Whether values should be listed horizontally (as columns) or vertically (as rows).
|
List<PivotValue> |
getValues()
A list of values to include in the pivot table.
|
PivotTable |
set(String fieldName,
Object value) |
PivotTable |
setColumns(List<PivotGroup> columns)
Each column grouping in the pivot table.
|
PivotTable |
setCriteria(Map<String,PivotFilterCriteria> criteria)
An optional mapping of filters per source column offset.
|
PivotTable |
setDataExecutionStatus(DataExecutionStatus dataExecutionStatus)
Output only.
|
PivotTable |
setDataSourceId(String dataSourceId)
The ID of the data source the pivot table is reading data from.
|
PivotTable |
setFilterSpecs(List<PivotFilterSpec> filterSpecs)
The filters applied to the source columns before aggregating data for the pivot table.
|
PivotTable |
setRows(List<PivotGroup> rows)
Each row grouping in the pivot table.
|
PivotTable |
setSource(GridRange source)
The range the pivot table is reading data from.
|
PivotTable |
setValueLayout(String valueLayout)
Whether values should be listed horizontally (as columns) or vertically (as rows).
|
PivotTable |
setValues(List<PivotValue> values)
A list of values to include in the pivot table.
|
getFactory, setFactory, toPrettyString, toString
entrySet, equals, get, getClassInfo, getUnknownKeys, hashCode, put, putAll, remove, setUnknownKeys
clear, containsKey, containsValue, isEmpty, keySet, size, values
finalize, getClass, notify, notifyAll, wait, wait, wait
compute, computeIfAbsent, computeIfPresent, forEach, getOrDefault, merge, putIfAbsent, remove, replace, replace, replaceAll
public List<PivotGroup> getColumns()
null
for nonepublic PivotTable setColumns(List<PivotGroup> columns)
columns
- columns or null
for nonepublic Map<String,PivotFilterCriteria> getCriteria()
null
for nonepublic PivotTable setCriteria(Map<String,PivotFilterCriteria> criteria)
criteria
- criteria or null
for nonepublic DataExecutionStatus getDataExecutionStatus()
null
for nonepublic PivotTable setDataExecutionStatus(DataExecutionStatus dataExecutionStatus)
dataExecutionStatus
- dataExecutionStatus or null
for nonepublic String getDataSourceId()
null
for nonepublic PivotTable setDataSourceId(String dataSourceId)
dataSourceId
- dataSourceId or null
for nonepublic List<PivotFilterSpec> getFilterSpecs()
null
for nonepublic PivotTable setFilterSpecs(List<PivotFilterSpec> filterSpecs)
filterSpecs
- filterSpecs or null
for nonepublic List<PivotGroup> getRows()
null
for nonepublic PivotTable setRows(List<PivotGroup> rows)
rows
- rows or null
for nonepublic GridRange getSource()
null
for nonepublic PivotTable setSource(GridRange source)
source
- source or null
for nonepublic String getValueLayout()
null
for nonepublic PivotTable setValueLayout(String valueLayout)
valueLayout
- valueLayout or null
for nonepublic List<PivotValue> getValues()
null
for nonepublic PivotTable setValues(List<PivotValue> values)
values
- values or null
for nonepublic PivotTable set(String fieldName, Object value)
set
in class com.google.api.client.json.GenericJson
public PivotTable clone()
clone
in class com.google.api.client.json.GenericJson
Copyright © 2011–2024 Google. All rights reserved.