Uses of Package
com.google.api.services.sheets.v4.model

Packages that use com.google.api.services.sheets.v4.model

Package	Description
com.google.api.services.sheets.v4
com.google.api.services.sheets.v4.model

Classes in com.google.api.services.sheets.v4.model used by com.google.api.services.sheets.v4

Class and Description
BatchClearValuesByDataFilterRequest The request for clearing more than one range selected by a DataFilter in a spreadsheet.
BatchClearValuesRequest The request for clearing more than one range of values in a spreadsheet.
BatchGetValuesByDataFilterRequest The request for retrieving a range of values in a spreadsheet selected by a set of DataFilters.
BatchUpdateSpreadsheetRequest The request for updating any aspect of a spreadsheet.
BatchUpdateValuesByDataFilterRequest The request for updating more than one range of values in a spreadsheet.
BatchUpdateValuesRequest The request for updating more than one range of values in a spreadsheet.
ClearValuesRequest The request for clearing a range of values in a spreadsheet.
CopySheetToAnotherSpreadsheetRequest The request to copy a sheet across spreadsheets.
GetSpreadsheetByDataFilterRequest The request for retrieving a Spreadsheet.
SearchDeveloperMetadataRequest A request to retrieve all developer metadata matching the set of specified criteria.
Spreadsheet Resource that represents a spreadsheet.
ValueRange Data within a range of the spreadsheet.

Classes in com.google.api.services.sheets.v4.model used by com.google.api.services.sheets.v4.model

Class and 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.