Adds a new banded range to the spreadsheet.
The result of adding a banded range.
Adds a chart to a sheet in the spreadsheet.
The result of adding a chart to a spreadsheet.
Adds a new conditional format rule at the given index.
All subsequent rules’ indexes are incremented.
Creates a group over the specified range.
The result of adding a group.
The result of adding a filter view.
Adds a named range to the spreadsheet.
The result of adding a named range.
Adds a new protected range.
The result of adding a new protected range.
Adds a new sheet.
When a sheet is added at a given index,
all subsequent sheets’ indexes are incremented.
To add an object sheet, use AddChartRequest instead and specify
EmbeddedObjectPosition.sheetId or
EmbeddedObjectPosition.newSheet.
The result of adding a sheet.
Adds new cells after the last row with data in a sheet,
inserting new rows into the sheet if necessary.
Appends rows or columns to the end of a sheet.
The response when updating a range of values in a spreadsheet.
Fills in more data based on existing data.
Automatically resizes one or more dimensions based on the contents
of the cells in that dimension.
A banded (alternating colors) range in a sheet.
Properties referring a single dimension (either row or column). If both
BandedRange.row_properties and BandedRange.column_properties are
set, the fill colors are applied to cells according to the following rules:
An axis of the chart.
A chart may not have more than one axis per
axis position.
The domain of a chart.
For example, if charting stock prices over time, this would be the date.
A single series of data in a chart.
For example, if charting stock prices over time, multiple series may exist,
one for the “Open Price”, “High Price”, “Low Price” and “Close Price”.
The specification for a basic chart. See BasicChartType for the list
of charts this supports.
The default filter associated with a sheet.
The request for clearing more than one range selected by a
DataFilter in a spreadsheet.
The response when clearing a range of values selected with
DataFilters in a spreadsheet.
The request for clearing more than one range of values in a spreadsheet.
The response when clearing a range of values in a spreadsheet.
The request for retrieving a range of values in a spreadsheet selected by a
set of DataFilters.
The response when retrieving more than one range of values in a spreadsheet
selected by DataFilters.
The response when retrieving more than one range of values in a spreadsheet.
The request for updating any aspect of a spreadsheet.
The reply for batch updating a spreadsheet.
The request for updating more than one range of values in a spreadsheet.
The response when updating a range of values in a spreadsheet.
The request for updating more than one range of values in a spreadsheet.
The response when updating a range of values in a spreadsheet.
A condition that can evaluate to true or false.
BooleanConditions are used by conditional formatting,
data validation, and the criteria in filters.
A rule that may or may not match, depending on the condition.
The Candlestick chart data, each containing the low, open, close, and high
values for a series.
The domain of a CandlestickChart.
The series of a CandlestickData.
Data about a specific cell.
The data included in a domain or series.
Source ranges for a chart.
The specifications of a chart.
Clears the basic filter, if any exists on the sheet.
The request for clearing a range of values in a spreadsheet.
The response when clearing a range of values in a spreadsheet.
Represents a color in the RGBA color space. This representation is designed
for simplicity of conversion to/from color representations in various
languages over compactness; for example, the fields of this representation
can be trivially provided to the constructor of “java.awt.Color” in Java; it
can also be trivially provided to UIColor’s “+colorWithRed:green:blue:alpha”
method in iOS; and, with just a little work, it can be easily formatted into
a CSS “rgba()” string in JavaScript, as well. Here are some examples:
The value of the condition.
A rule describing a conditional format.
Copies data from the source to the destination.
The request to copy a sheet across spreadsheets.
A request to create developer metadata.
The response from creating developer metadata.
Moves data from the source to the destination.
Filter that describes what data should be selected or returned from a
request.
A range of values whose location is specified by a DataFilter.
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. For example,
consider a pivot table showing sales transactions by date:
A delegate with a conservative default implementation, which is used if no other delegate is
set.
Removes the banded range with the given ID from the spreadsheet.
Deletes a conditional format rule at the given index.
All subsequent rules’ indexes are decremented.
The result of deleting a conditional format rule.
A request to delete developer metadata.
The response from deleting developer metadata.
Deletes a group over the specified range by decrementing the depth of the
dimensions in the range.
The result of deleting a group.
Deletes the dimensions from the sheet.
Deletes the embedded object with the given ID.
Deletes a particular filter view.
Removes the named range with the given ID from the spreadsheet.
Deletes the protected range with the given ID.
Deletes a range of cells, shifting other cells into the deleted area.
Deletes the requested sheet.
Developer metadata associated with a location or object in a spreadsheet.
Developer metadata may be used to associate arbitrary data with various
parts of a spreadsheet and will remain associated at those locations as they
move around and the spreadsheet is edited. For example, if developer
metadata is associated with row 5 and another row is then subsequently
inserted above row 5, that original metadata will still be associated with
the row it was first associated with (what is now row 6). If the associated
object is deleted its metadata is deleted too.
A location where metadata may be associated in a spreadsheet.
Selects DeveloperMetadata that matches all of the specified fields. For
example, if only a metadata ID is specified this considers the
DeveloperMetadata with that particular unique ID. If a metadata key is
specified, this considers all developer metadata with that key. If a
key, visibility, and location type are all specified, this considers all
developer metadata with that key and visibility that are associated with a
location of that type. In general, this
selects all DeveloperMetadata that matches the intersection of all the
specified fields; any field or combination of fields may be specified.
A group over an interval of rows or columns on a sheet, which can contain or
be contained within other groups. A group can be collapsed or expanded as a
unit on the sheet.
Properties about a dimension.
A range along a single dimension on a sheet.
All indexes are zero-based.
Indexes are half open: the start index is inclusive
and the end index is exclusive.
Missing indexes indicate the range is unbounded on that side.
Duplicates a particular filter view.
The result of a filter view being duplicated.
Duplicates the contents of a sheet.
The result of duplicating a sheet.
The editors of a protected range.
A chart embedded in a sheet.
The position of an embedded object such as a chart.
A utility to represent detailed errors we might see in case there are BadRequests.
The latter happen if the sent parameters or request structures are unsound
The kinds of value that a cell in a spreadsheet can have.
Criteria for showing/hiding rows in a filter or filter view.
Finds and replaces data in cells over a range, sheet, or all sheets.
The result of the find/replace.
The request for retrieving a Spreadsheet.
A rule that applies a gradient color scale format, based on
the interpolation points listed. The format of a cell will vary
based on its contents as compared to the values of the interpolation
points.
A coordinate in a sheet.
All indexes are zero-based.
Data in the grid, as well as metadata about the dimensions.
A range on a sheet.
All indexes are zero-based.
Indexes are half open, e.g the start index is inclusive
and the end index is exclusive – [start_index, end_index).
Missing indexes indicate the range is unbounded on that side.
A
histogram chart.
A histogram chart groups data items into bins, displaying each bin as a
column of stacked items. Histograms are used to display the distribution
of a dataset. Each column of items represents a range into which those
items fall. The number of bins can be chosen automatically or specified
explicitly.
Allows you to organize the numeric values in a source data column into
buckets of a constant size. All values from HistogramRule.start to
HistogramRule.end are placed into groups of size
HistogramRule.interval. In addition, all values below
HistogramRule.start are placed in one group, and all values above
HistogramRule.end are placed in another. Only
HistogramRule.interval is required, though if HistogramRule.start
and HistogramRule.end are both provided, HistogramRule.start must
be less than HistogramRule.end. For example, a pivot table showing
average purchase amount by age that has 50+ rows:
A histogram series containing the series color and data.
Inserts rows or columns in a sheet at a particular index.
Inserts cells into a range, shifting the existing cells over or down.
A single interpolation point on a gradient conditional format.
These pin the gradient color scale according to the color,
type and value chosen.
Settings to control how circular dependencies are resolved with iterative
calculation.
Properties that describe the style of a line.
Allows you to manually organize the values in a source data column into
buckets with names of your choosing. For example, a pivot table that
aggregates population by state:
A group name and a list of items from the source data that should be placed
in the group with this name.
A developer metadata entry and the data filters specified in the original
request that matched it.
A value range that was matched by one or more data filers.
Merges all cells in the range.
Contains information about an API request.
Moves one or more rows or columns.
Provides a
Read
interface that converts multiple parts into the protocol
identified by
RFC2387.
Note: This implementation is just as rich as it needs to be to perform uploads
to google APIs, and might not be a fully-featured implementation.
The number format of a cell.
An
org chart.
Org charts require a unique set of labels in labels and may
optionally include parent_labels and tooltips.
parent_labels contain, for each node, the label identifying the parent
node. tooltips contain, for each node, an optional tooltip.
The location an object is overlaid on top of a grid.
The amount of padding around the cell, in pixels.
When updating padding, every field must be specified.
Inserts data into the spreadsheet starting at the specified coordinate.
Criteria for showing/hiding rows in a pivot table.
A single grouping (either row or column) in a pivot table.
An optional setting on a PivotGroup that defines buckets for the values
in the source data column rather than breaking out each individual value.
Only one PivotGroup with a group rule may be added for each column in
the source data, though on any given column you may add both a
PivotGroup that has a rule and a PivotGroup that does not.
Information about which values in a pivot group should be used for sorting.
Metadata about a value in a pivot grouping.
The definition of how a value in a pivot table should be calculated.
Randomizes the order of the rows in a range.
Updates all cells in the range to the values in the given Cell object.
Only the fields listed in the fields field are updated; others are
unchanged.
A single kind of update to apply to a spreadsheet.
A single response from an update.
Data about each cell in a row.
A request to retrieve all developer metadata matching the set of specified
criteria.
A reply to a developer metadata search request.
Sets the basic filter associated with a sheet.
Sets a data validation rule to every cell in the range.
To clear validation in a range, call this with no rule specified.
A sheet in a spreadsheet.
Central instance to access all Sheets related resource activities
Sorts data in rows based on a sort order per column.
A sort order associated with a specific column or row.
A combination of a source range and how to extend that source.
Resource that represents a spreadsheet.
Applies one or more updates to the spreadsheet.
Creates a spreadsheet, returning the newly created spreadsheet.
Returns the developer metadata with the specified ID.
The caller must specify the spreadsheet ID and the developer metadata’s
unique metadataId.
Returns all developer metadata matching the specified DataFilter.
If the provided DataFilter represents a DeveloperMetadataLookup object,
this will return all DeveloperMetadata entries selected by it. If the
DataFilter represents a location in a spreadsheet, this will return all
developer metadata associated with locations intersecting that region.
Returns the spreadsheet at the given ID.
The caller must specify the spreadsheet ID.
Returns the spreadsheet at the given ID.
The caller must specify the spreadsheet ID.
A builder providing access to all methods supported on spreadsheet resources.
It is not used directly, but through the Sheets
hub.
Properties of a spreadsheet.
Copies a single sheet from a spreadsheet to another spreadsheet.
Returns the properties of the newly created sheet.
Appends values to a spreadsheet. The input range is used to search for
existing data and find a “table” within that range. Values will be
appended to the next row of the table, starting with the first column of
the table. See the
guide
and
sample code
for specific details of how tables are detected and data is appended.
Clears one or more ranges of values from a spreadsheet.
The caller must specify the spreadsheet ID and one or more
DataFilters. Ranges matching any of the specified data
filters will be cleared. Only values are cleared – all other properties
of the cell (such as formatting, data validation, etc..) are kept.
Clears one or more ranges of values from a spreadsheet.
The caller must specify the spreadsheet ID and one or more ranges.
Only values are cleared – all other properties of the cell (such as
formatting, data validation, etc..) are kept.
Returns one or more ranges of values that match the specified data filters.
The caller must specify the spreadsheet ID and one or more
DataFilters. Ranges that match any of the data filters in
the request will be returned.
Returns one or more ranges of values from a spreadsheet.
The caller must specify the spreadsheet ID and one or more ranges.
Sets values in one or more ranges of a spreadsheet.
The caller must specify the spreadsheet ID,
a valueInputOption, and one or more
DataFilterValueRanges.
Sets values in one or more ranges of a spreadsheet.
The caller must specify the spreadsheet ID,
a valueInputOption, and one or more
ValueRanges.
Clears values from a spreadsheet.
The caller must specify the spreadsheet ID and range.
Only values are cleared – all other properties of the cell (such as
formatting, data validation, etc..) are kept.
Returns a range of values from a spreadsheet.
The caller must specify the spreadsheet ID and a range.
Sets values in a range of a spreadsheet.
The caller must specify the spreadsheet ID, range, and
a valueInputOption.
The format of a run of text in a cell.
Absent values indicate that the field isn’t specified.
A run of a text format. The format of this run continues until the start
index of the next run.
When updating, all fields must be set.
Position settings for text.
The rotation applied to text in a cell.
Splits a column of text into multiple columns,
based on a delimiter in each cell.
A color scale for a treemap chart.
Unmerges cells in the given range.
Updates properties of the supplied banded range.
Updates the borders of a range.
If a field is not set in the request, that means the border remains as-is.
For example, with two subsequent UpdateBordersRequest:
Updates all cells in a range with new data.
Updates a chart’s specifications.
(This does not move or resize a chart. To move or resize a chart, use
UpdateEmbeddedObjectPositionRequest.)
Updates a conditional format rule at the given index,
or moves a conditional format rule to another index.
The result of updating a conditional format rule.
A request to update properties of developer metadata.
Updates the properties of the developer metadata selected by the filters to
the values provided in the DeveloperMetadata resource. Callers must
specify the properties they wish to update in the fields parameter, as well
as specify at least one DataFilter matching the metadata they wish to
update.
The response from updating developer metadata.
Updates the state of the specified group.
Updates properties of dimensions within the specified range.
Update an embedded object’s position (such as a moving or resizing a
chart or image).
The result of updating an embedded object’s position.
Updates properties of the filter view.
Updates properties of the named range with the specified
namedRangeId.
Updates an existing protected range with the specified
protectedRangeId.
Updates properties of the sheet with the specified
sheetId.
Updates properties of a spreadsheet.
The response when updating a range of values by a data filter in a
spreadsheet.
The response when updating a range of values in a spreadsheet.
Data within a range of the spreadsheet.
Styles for a waterfall chart column.
A custom subtotal column for a waterfall chart series.
The domain of a waterfall chart.
A single series of data for a waterfall chart.