Class | Description |
---|---|
AddBandingRequest |
Adds a new banded range to the spreadsheet.
|
AddBandingResponse |
The result of adding a banded range.
|
AddChartRequest |
Adds a chart to a sheet in the spreadsheet.
|
AddChartResponse |
The result of adding a chart to a spreadsheet.
|
AddConditionalFormatRuleRequest |
Adds a new conditional format rule at the given index.
|
AddDataSourceRequest |
Adds a data source.
|
AddDataSourceResponse |
The result of adding a data source.
|
AddDimensionGroupRequest |
Creates a group over the specified range.
|
AddDimensionGroupResponse |
The result of adding a group.
|
AddFilterViewRequest |
Adds a filter view.
|
AddFilterViewResponse |
The result of adding a filter view.
|
AddNamedRangeRequest |
Adds a named range to the spreadsheet.
|
AddNamedRangeResponse |
The result of adding a named range.
|
AddProtectedRangeRequest |
Adds a new protected range.
|
AddProtectedRangeResponse |
The result of adding a new protected range.
|
AddSheetRequest |
Adds a new sheet.
|
AddSheetResponse |
The result of adding a sheet.
|
AddSlicerRequest |
Adds a slicer to a sheet in the spreadsheet.
|
AddSlicerResponse |
The result of adding a slicer to a spreadsheet.
|
AppendCellsRequest |
Adds new cells after the last row with data in a sheet, inserting new rows into the sheet if
necessary.
|
AppendDimensionRequest |
Appends rows or columns to the end of a sheet.
|
AppendValuesResponse |
The response when updating a range of values in a spreadsheet.
|
AutoFillRequest |
Fills in more data based on existing data.
|
AutoResizeDimensionsRequest |
Automatically resizes one or more dimensions based on the contents of the cells in that
dimension.
|
BandedRange |
A banded (alternating colors) range in a sheet.
|
BandingProperties |
Properties referring a single dimension (either row or column).
|
BaselineValueFormat |
Formatting options for baseline value.
|
BasicChartAxis |
An axis of the chart.
|
BasicChartDomain |
The domain of a chart.
|
BasicChartSeries |
A single series of data in a chart.
|
BasicChartSpec |
The specification for a basic chart.
|
BasicFilter |
The default filter associated with a sheet.
|
BasicSeriesDataPointStyleOverride |
Style override settings for a single series data point.
|
BatchClearValuesByDataFilterRequest |
The request for clearing more than one range selected by a DataFilter in a spreadsheet.
|
BatchClearValuesByDataFilterResponse |
The response when clearing a range of values selected with DataFilters in a spreadsheet.
|
BatchClearValuesRequest |
The request for clearing more than one range of values in a spreadsheet.
|
BatchClearValuesResponse |
The response when clearing a range of values in a spreadsheet.
|
BatchGetValuesByDataFilterRequest |
The request for retrieving a range of values in a spreadsheet selected by a set of DataFilters.
|
BatchGetValuesByDataFilterResponse |
The response when retrieving more than one range of values in a spreadsheet selected by
DataFilters.
|
BatchGetValuesResponse |
The response when retrieving more than one range of values in a spreadsheet.
|
BatchUpdateSpreadsheetRequest |
The request for updating any aspect of a spreadsheet.
|
BatchUpdateSpreadsheetResponse |
The reply for batch updating a spreadsheet.
|
BatchUpdateValuesByDataFilterRequest |
The request for updating more than one range of values in a spreadsheet.
|
BatchUpdateValuesByDataFilterResponse |
The response when updating a range of values in a spreadsheet.
|
BatchUpdateValuesRequest |
The request for updating more than one range of values in a spreadsheet.
|
BatchUpdateValuesResponse |
The response when updating a range of values in a spreadsheet.
|
BigQueryDataSourceSpec |
The specification of a BigQuery data source that's connected to a sheet.
|
BigQueryQuerySpec |
Specifies a custom BigQuery query.
|
BigQueryTableSpec |
Specifies a BigQuery table definition.
|
BooleanCondition |
A condition that can evaluate to true or false.
|
BooleanRule |
A rule that may or may not match, depending on the condition.
|
Border |
A border along a cell.
|
Borders |
The borders of the cell.
|
BubbleChartSpec |
A bubble chart.
|
CancelDataSourceRefreshRequest |
Cancels one or multiple refreshes of data source objects in the spreadsheet by the specified
references.
|
CancelDataSourceRefreshResponse |
The response from cancelling one or multiple data source object refreshes.
|
CancelDataSourceRefreshStatus |
The status of cancelling a single data source object refresh.
|
CandlestickChartSpec |
A candlestick chart.
|
CandlestickData |
The Candlestick chart data, each containing the low, open, close, and high values for a series.
|
CandlestickDomain |
The domain of a CandlestickChart.
|
CandlestickSeries |
The series of a CandlestickData.
|
CellData |
Data about a specific cell.
|
CellFormat |
The format of a cell.
|
ChartAxisViewWindowOptions |
The options that define a "view window" for a chart (such as the visible values in an axis).
|
ChartCustomNumberFormatOptions |
Custom number formatting options for chart attributes.
|
ChartData |
The data included in a domain or series.
|
ChartDateTimeRule |
Allows you to organize the date-time values in a source data column into buckets based on
selected parts of their date or time values.
|
ChartGroupRule |
An optional setting on the ChartData of the domain of a data source chart that defines buckets
for the values in the domain rather than breaking out each individual value.
|
ChartHistogramRule |
Allows you to organize numeric values in a source data column into buckets of constant size.
|
ChartSourceRange |
Source ranges for a chart.
|
ChartSpec |
The specifications of a chart.
|
ClearBasicFilterRequest |
Clears the basic filter, if any exists on the sheet.
|
ClearValuesRequest |
The request for clearing a range of values in a spreadsheet.
|
ClearValuesResponse |
The response when clearing a range of values in a spreadsheet.
|
Color |
Represents a color in the RGBA color space.
|
ColorStyle |
A color value.
|
ConditionalFormatRule |
A rule describing a conditional format.
|
ConditionValue |
The value of the condition.
|
CopyPasteRequest |
Copies data from the source to the destination.
|
CopySheetToAnotherSpreadsheetRequest |
The request to copy a sheet across spreadsheets.
|
CreateDeveloperMetadataRequest |
A request to create developer metadata.
|
CreateDeveloperMetadataResponse |
The response from creating developer metadata.
|
CutPasteRequest |
Moves data from the source to the destination.
|
DataExecutionStatus |
The data execution status.
|
DataFilter |
Filter that describes what data should be selected or returned from a request.
|
DataFilterValueRange |
A range of values whose location is specified by a DataFilter.
|
DataLabel |
Settings for one set of data labels.
|
DataSource |
Information about an external data source in the spreadsheet.
|
DataSourceChartProperties |
Properties of a data source chart.
|
DataSourceColumn |
A column in a data source.
|
DataSourceColumnReference |
An unique identifier that references a data source column.
|
DataSourceFormula |
A data source formula.
|
DataSourceObjectReference |
Reference to a data source object.
|
DataSourceObjectReferences |
A list of references to data source objects.
|
DataSourceParameter |
A parameter in a data source's query.
|
DataSourceRefreshDailySchedule |
A schedule for data to refresh every day in a given time interval.
|
DataSourceRefreshMonthlySchedule |
A monthly schedule for data to refresh on specific days in the month in a given time interval.
|
DataSourceRefreshSchedule |
Schedule for refreshing the data source.
|
DataSourceRefreshWeeklySchedule |
A weekly schedule for data to refresh on specific days in a given time interval.
|
DataSourceSheetDimensionRange |
A range along a single dimension on a DATA_SOURCE sheet.
|
DataSourceSheetProperties |
Additional properties of a DATA_SOURCE sheet.
|
DataSourceSpec |
This specifies the details of the data source.
|
DataSourceTable |
A data source table, which allows the user to import a static table of data from the DataSource
into Sheets.
|
DataValidationRule |
A data validation rule.
|
DateTimeRule |
Allows you to organize the date-time values in a source data column into buckets based on
selected parts of their date or time values.
|
DeleteBandingRequest |
Removes the banded range with the given ID from the spreadsheet.
|
DeleteConditionalFormatRuleRequest |
Deletes a conditional format rule at the given index.
|
DeleteConditionalFormatRuleResponse |
The result of deleting a conditional format rule.
|
DeleteDataSourceRequest |
Deletes a data source.
|
DeleteDeveloperMetadataRequest |
A request to delete developer metadata.
|
DeleteDeveloperMetadataResponse |
The response from deleting developer metadata.
|
DeleteDimensionGroupRequest |
Deletes a group over the specified range by decrementing the depth of the dimensions in the
range.
|
DeleteDimensionGroupResponse |
The result of deleting a group.
|
DeleteDimensionRequest |
Deletes the dimensions from the sheet.
|
DeleteDuplicatesRequest |
Removes rows within this range that contain values in the specified columns that are duplicates
of values in any previous row.
|
DeleteDuplicatesResponse |
The result of removing duplicates in a range.
|
DeleteEmbeddedObjectRequest |
Deletes the embedded object with the given ID.
|
DeleteFilterViewRequest |
Deletes a particular filter view.
|
DeleteNamedRangeRequest |
Removes the named range with the given ID from the spreadsheet.
|
DeleteProtectedRangeRequest |
Deletes the protected range with the given ID.
|
DeleteRangeRequest |
Deletes a range of cells, shifting other cells into the deleted area.
|
DeleteSheetRequest |
Deletes the requested sheet.
|
DeveloperMetadata |
Developer metadata associated with a location or object in a spreadsheet.
|
DeveloperMetadataLocation |
A location where metadata may be associated in a spreadsheet.
|
DeveloperMetadataLookup |
Selects DeveloperMetadata that matches all of the specified fields.
|
DimensionGroup |
A group over an interval of rows or columns on a sheet, which can contain or be contained within
other groups.
|
DimensionProperties |
Properties about a dimension.
|
DimensionRange |
A range along a single dimension on a sheet.
|
DuplicateFilterViewRequest |
Duplicates a particular filter view.
|
DuplicateFilterViewResponse |
The result of a filter view being duplicated.
|
DuplicateSheetRequest |
Duplicates the contents of a sheet.
|
DuplicateSheetResponse |
The result of duplicating a sheet.
|
Editors |
The editors of a protected range.
|
EmbeddedChart |
A chart embedded in a sheet.
|
EmbeddedObjectBorder |
A border along an embedded object.
|
EmbeddedObjectPosition |
The position of an embedded object such as a chart.
|
ErrorValue |
An error in a cell.
|
ExtendedValue |
The kinds of value that a cell in a spreadsheet can have.
|
FilterCriteria |
Criteria for showing/hiding rows in a filter or filter view.
|
FilterSpec |
The filter criteria associated with a specific column.
|
FilterView |
A filter view.
|
FindReplaceRequest |
Finds and replaces data in cells over a range, sheet, or all sheets.
|
FindReplaceResponse |
The result of the find/replace.
|
GetSpreadsheetByDataFilterRequest |
The request for retrieving a Spreadsheet.
|
GradientRule |
A rule that applies a gradient color scale format, based on the interpolation points listed.
|
GridCoordinate |
A coordinate in a sheet.
|
GridData |
Data in the grid, as well as metadata about the dimensions.
|
GridProperties |
Properties of a grid.
|
GridRange |
A range on a sheet.
|
HistogramChartSpec |
A histogram chart.
|
HistogramRule |
Allows you to organize the numeric values in a source data column into buckets of a constant
size.
|
HistogramSeries |
A histogram series containing the series color and data.
|
InsertDimensionRequest |
Inserts rows or columns in a sheet at a particular index.
|
InsertRangeRequest |
Inserts cells into a range, shifting the existing cells over or down.
|
InterpolationPoint |
A single interpolation point on a gradient conditional format.
|
Interval |
Represents a time interval, encoded as a Timestamp start (inclusive) and a Timestamp end
(exclusive).
|
IterativeCalculationSettings |
Settings to control how circular dependencies are resolved with iterative calculation.
|
KeyValueFormat |
Formatting options for key value.
|
LineStyle |
Properties that describe the style of a line.
|
Link |
An external or local reference.
|
LookerDataSourceSpec |
The specification of a Looker data source.
|
ManualRule |
Allows you to manually organize the values in a source data column into buckets with names of
your choosing.
|
ManualRuleGroup |
A group name and a list of items from the source data that should be placed in the group with
this name.
|
MatchedDeveloperMetadata |
A developer metadata entry and the data filters specified in the original request that matched
it.
|
MatchedValueRange |
A value range that was matched by one or more data filers.
|
MergeCellsRequest |
Merges all cells in the range.
|
MoveDimensionRequest |
Moves one or more rows or columns.
|
NamedRange |
A named range.
|
NumberFormat |
The number format of a cell.
|
OrgChartSpec |
An org chart.
|
OverlayPosition |
The location an object is overlaid on top of a grid.
|
Padding |
The amount of padding around the cell, in pixels.
|
PasteDataRequest |
Inserts data into the spreadsheet starting at the specified coordinate.
|
PieChartSpec |
A pie chart.
|
PivotFilterCriteria |
Criteria for showing/hiding rows in a pivot table.
|
PivotFilterSpec |
The pivot table filter criteria associated with a specific source column offset.
|
PivotGroup |
A single grouping (either row or column) in a pivot table.
|
PivotGroupLimit |
The count limit on rows or columns in the pivot group.
|
PivotGroupRule |
An optional setting on a PivotGroup that defines buckets for the values in the source data column
rather than breaking out each individual value.
|
PivotGroupSortValueBucket |
Information about which values in a pivot group should be used for sorting.
|
PivotGroupValueMetadata |
Metadata about a value in a pivot grouping.
|
PivotTable |
A pivot table.
|
PivotValue |
The definition of how a value in a pivot table should be calculated.
|
PointStyle |
The style of a point on the chart.
|
ProtectedRange |
A protected range.
|
RandomizeRangeRequest |
Randomizes the order of the rows in a range.
|
RefreshCancellationStatus |
The status of a refresh cancellation.
|
RefreshDataSourceObjectExecutionStatus |
The execution status of refreshing one data source object.
|
RefreshDataSourceRequest |
Refreshes one or multiple data source objects in the spreadsheet by the specified references.
|
RefreshDataSourceResponse |
The response from refreshing one or multiple data source objects.
|
RepeatCellRequest |
Updates all cells in the range to the values in the given Cell object.
|
Request |
A single kind of update to apply to a spreadsheet.
|
Response |
A single response from an update.
|
RowData |
Data about each cell in a row.
|
ScorecardChartSpec |
A scorecard chart.
|
SearchDeveloperMetadataRequest |
A request to retrieve all developer metadata matching the set of specified criteria.
|
SearchDeveloperMetadataResponse |
A reply to a developer metadata search request.
|
SetBasicFilterRequest |
Sets the basic filter associated with a sheet.
|
SetDataValidationRequest |
Sets a data validation rule to every cell in the range.
|
Sheet |
A sheet in a spreadsheet.
|
SheetProperties |
Properties of a sheet.
|
Slicer |
A slicer in a sheet.
|
SlicerSpec |
The specifications of a slicer.
|
SortRangeRequest |
Sorts data in rows based on a sort order per column.
|
SortSpec |
A sort order associated with a specific column or row.
|
SourceAndDestination |
A combination of a source range and how to extend that source.
|
Spreadsheet |
Resource that represents a spreadsheet.
|
SpreadsheetProperties |
Properties of a spreadsheet.
|
SpreadsheetTheme |
Represents spreadsheet theme
|
TextFormat |
The format of a run of text in a cell.
|
TextFormatRun |
A run of a text format.
|
TextPosition |
Position settings for text.
|
TextRotation |
The rotation applied to text in a cell.
|
TextToColumnsRequest |
Splits a column of text into multiple columns, based on a delimiter in each cell.
|
ThemeColorPair |
A pair mapping a spreadsheet theme color type to the concrete color it represents.
|
TimeOfDay |
Represents a time of day.
|
TreemapChartColorScale |
A color scale for a treemap chart.
|
TreemapChartSpec |
A Treemap chart.
|
TrimWhitespaceRequest |
Trims the whitespace (such as spaces, tabs, or new lines) in every cell in the specified range.
|
TrimWhitespaceResponse |
The result of trimming whitespace in cells.
|
UnmergeCellsRequest |
Unmerges cells in the given range.
|
UpdateBandingRequest |
Updates properties of the supplied banded range.
|
UpdateBordersRequest |
Updates the borders of a range.
|
UpdateCellsRequest |
Updates all cells in a range with new data.
|
UpdateChartSpecRequest |
Updates a chart's specifications.
|
UpdateConditionalFormatRuleRequest |
Updates a conditional format rule at the given index, or moves a conditional format rule to
another index.
|
UpdateConditionalFormatRuleResponse |
The result of updating a conditional format rule.
|
UpdateDataSourceRequest |
Updates a data source.
|
UpdateDataSourceResponse |
The response from updating data source.
|
UpdateDeveloperMetadataRequest |
A request to update properties of developer metadata.
|
UpdateDeveloperMetadataResponse |
The response from updating developer metadata.
|
UpdateDimensionGroupRequest |
Updates the state of the specified group.
|
UpdateDimensionPropertiesRequest |
Updates properties of dimensions within the specified range.
|
UpdateEmbeddedObjectBorderRequest |
Updates an embedded object's border property.
|
UpdateEmbeddedObjectPositionRequest |
Update an embedded object's position (such as a moving or resizing a chart or image).
|
UpdateEmbeddedObjectPositionResponse |
The result of updating an embedded object's position.
|
UpdateFilterViewRequest |
Updates properties of the filter view.
|
UpdateNamedRangeRequest |
Updates properties of the named range with the specified namedRangeId.
|
UpdateProtectedRangeRequest |
Updates an existing protected range with the specified protectedRangeId.
|
UpdateSheetPropertiesRequest |
Updates properties of the sheet with the specified sheetId.
|
UpdateSlicerSpecRequest |
Updates a slicer's specifications.
|
UpdateSpreadsheetPropertiesRequest |
Updates properties of a spreadsheet.
|
UpdateValuesByDataFilterResponse |
The response when updating a range of values by a data filter in a spreadsheet.
|
UpdateValuesResponse |
The response when updating a range of values in a spreadsheet.
|
ValueRange |
Data within a range of the spreadsheet.
|
WaterfallChartColumnStyle |
Styles for a waterfall chart column.
|
WaterfallChartCustomSubtotal |
A custom subtotal column for a waterfall chart series.
|
WaterfallChartDomain |
The domain of a waterfall chart.
|
WaterfallChartSeries |
A single series of data for a waterfall chart.
|
WaterfallChartSpec |
A waterfall chart.
|
Copyright © 2011–2024 Google. All rights reserved.