Google.Apis.Sheets.v4.Data Namespace Reference

Classes
class	AddBandingRequest
	Adds a new banded range to the spreadsheet. More...
class	AddBandingResponse
	The result of adding a banded range. More...
class	AddChartRequest
	Adds a chart to a sheet in the spreadsheet. More...
class	AddChartResponse
	The result of adding a chart to a spreadsheet. More...
class	AddConditionalFormatRuleRequest
	Adds a new conditional format rule at the given index. All subsequent rules' indexes are incremented. More...
class	AddDimensionGroupRequest
	Creates a group over the specified range. More...
class	AddDimensionGroupResponse
	The result of adding a group. More...
class	AddFilterViewRequest
	Adds a filter view. More...
class	AddFilterViewResponse
	The result of adding a filter view. More...
class	AddNamedRangeRequest
	Adds a named range to the spreadsheet. More...
class	AddNamedRangeResponse
	The result of adding a named range. More...
class	AddProtectedRangeRequest
	Adds a new protected range. More...
class	AddProtectedRangeResponse
	The result of adding a new protected range. More...
class	AddSheetRequest
	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. More...
class	AddSheetResponse
	The result of adding a sheet. More...
class	AddSlicerRequest
	Adds a slicer to a sheet in the spreadsheet. More...
class	AddSlicerResponse
	The result of adding a slicer to a spreadsheet. More...
class	AppendCellsRequest
	Adds new cells after the last row with data in a sheet, inserting new rows into the sheet if necessary. More...
class	AppendDimensionRequest
	Appends rows or columns to the end of a sheet. More...
class	AppendValuesResponse
	The response when updating a range of values in a spreadsheet. More...
class	AutoFillRequest
	Fills in more data based on existing data. More...
class	AutoResizeDimensionsRequest
	Automatically resizes one or more dimensions based on the contents of the cells in that dimension. More...
class	BandedRange
	A banded (alternating colors) range in a sheet. More...
class	BandingProperties
	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: More...
class	BaselineValueFormat
	Formatting options for baseline value. More...
class	BasicChartAxis
	An axis of the chart. A chart may not have more than one axis per axis position. More...
class	BasicChartDomain
	The domain of a chart. For example, if charting stock prices over time, this would be the date. More...
class	BasicChartSeries
	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". More...
class	BasicChartSpec
	The specification for a basic chart. See BasicChartType for the list of charts this supports. More...
class	BasicFilter
	The default filter associated with a sheet. More...
class	BatchClearValuesByDataFilterRequest
	The request for clearing more than one range selected by a DataFilter in a spreadsheet. More...
class	BatchClearValuesByDataFilterResponse
	The response when clearing a range of values selected with DataFilters in a spreadsheet. More...
class	BatchClearValuesRequest
	The request for clearing more than one range of values in a spreadsheet. More...
class	BatchClearValuesResponse
	The response when clearing a range of values in a spreadsheet. More...
class	BatchGetValuesByDataFilterRequest
	The request for retrieving a range of values in a spreadsheet selected by a set of DataFilters. More...
class	BatchGetValuesByDataFilterResponse
	The response when retrieving more than one range of values in a spreadsheet selected by DataFilters. More...
class	BatchGetValuesResponse
	The response when retrieving more than one range of values in a spreadsheet. More...
class	BatchUpdateSpreadsheetRequest
	The request for updating any aspect of a spreadsheet. More...
class	BatchUpdateSpreadsheetResponse
	The reply for batch updating a spreadsheet. More...
class	BatchUpdateValuesByDataFilterRequest
	The request for updating more than one range of values in a spreadsheet. More...
class	BatchUpdateValuesByDataFilterResponse
	The response when updating a range of values in a spreadsheet. More...
class	BatchUpdateValuesRequest
	The request for updating more than one range of values in a spreadsheet. More...
class	BatchUpdateValuesResponse
	The response when updating a range of values in a spreadsheet. More...
class	BooleanCondition
	A condition that can evaluate to true or false. BooleanConditions are used by conditional formatting, data validation, and the criteria in filters. More...
class	BooleanRule
	A rule that may or may not match, depending on the condition. More...
class	Border
	A border along a cell. More...
class	Borders
	The borders of the cell. More...
class	BubbleChartSpec
	A bubble chart. More...
class	CandlestickChartSpec
	A candlestick chart. More...
class	CandlestickData
	The Candlestick chart data, each containing the low, open, close, and high values for a series. More...
class	CandlestickDomain
	The domain of a CandlestickChart. More...
class	CandlestickSeries
	The series of a CandlestickData. More...
class	CellData
	Data about a specific cell. More...
class	CellFormat
	The format of a cell. More...
class	ChartAxisViewWindowOptions
	The options that define a "view window" for a chart (such as the visible values in an axis). More...
class	ChartCustomNumberFormatOptions
	Custom number formatting options for chart attributes. More...
class	ChartData
	The data included in a domain or series. More...
class	ChartSourceRange
	Source ranges for a chart. More...
class	ChartSpec
	The specifications of a chart. More...
class	ClearBasicFilterRequest
	Clears the basic filter, if any exists on the sheet. More...
class	ClearValuesRequest
	The request for clearing a range of values in a spreadsheet. More...
class	ClearValuesResponse
	The response when clearing a range of values in a spreadsheet. More...
class	Color
	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. More...
class	ColorStyle
	A color value. More...
class	ConditionalFormatRule
	A rule describing a conditional format. More...
class	ConditionValue
	The value of the condition. More...
class	CopyPasteRequest
	Copies data from the source to the destination. More...
class	CopySheetToAnotherSpreadsheetRequest
	The request to copy a sheet across spreadsheets. More...
class	CreateDeveloperMetadataRequest
	A request to create developer metadata. More...
class	CreateDeveloperMetadataResponse
	The response from creating developer metadata. More...
class	CutPasteRequest
	Moves data from the source to the destination. More...
class	DataFilter
	Filter that describes what data should be selected or returned from a request. More...
class	DataFilterValueRange
	A range of values whose location is specified by a DataFilter. More...
class	DataValidationRule
	A data validation rule. More...
class	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. For example, consider a pivot table showing sales transactions by date: More...
class	DeleteBandingRequest
	Removes the banded range with the given ID from the spreadsheet. More...
class	DeleteConditionalFormatRuleRequest
	Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented. More...
class	DeleteConditionalFormatRuleResponse
	The result of deleting a conditional format rule. More...
class	DeleteDeveloperMetadataRequest
	A request to delete developer metadata. More...
class	DeleteDeveloperMetadataResponse
	The response from deleting developer metadata. More...
class	DeleteDimensionGroupRequest
	Deletes a group over the specified range by decrementing the depth of the dimensions in the range. More...
class	DeleteDimensionGroupResponse
	The result of deleting a group. More...
class	DeleteDimensionRequest
	Deletes the dimensions from the sheet. More...
class	DeleteDuplicatesRequest
	Removes rows within this range that contain values in the specified columns that are duplicates of values in any previous row. Rows with identical values but different letter cases, formatting, or formulas are considered to be duplicates. More...
class	DeleteDuplicatesResponse
	The result of removing duplicates in a range. More...
class	DeleteEmbeddedObjectRequest
	Deletes the embedded object with the given ID. More...
class	DeleteFilterViewRequest
	Deletes a particular filter view. More...
class	DeleteNamedRangeRequest
	Removes the named range with the given ID from the spreadsheet. More...
class	DeleteProtectedRangeRequest
	Deletes the protected range with the given ID. More...
class	DeleteRangeRequest
	Deletes a range of cells, shifting other cells into the deleted area. More...
class	DeleteSheetRequest
	Deletes the requested sheet. More...
class	DeveloperMetadata
	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. More...
class	DeveloperMetadataLocation
	A location where metadata may be associated in a spreadsheet. More...
class	DeveloperMetadataLookup
	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. More...
class	DimensionGroup
	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. More...
class	DimensionProperties
	Properties about a dimension. More...
class	DimensionRange
	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. More...
class	DuplicateFilterViewRequest
	Duplicates a particular filter view. More...
class	DuplicateFilterViewResponse
	The result of a filter view being duplicated. More...
class	DuplicateSheetRequest
	Duplicates the contents of a sheet. More...
class	DuplicateSheetResponse
	The result of duplicating a sheet. More...
class	Editors
	The editors of a protected range. More...
class	EmbeddedChart
	A chart embedded in a sheet. More...
class	EmbeddedObjectPosition
	The position of an embedded object such as a chart. More...
class	ErrorValue
	An error in a cell. More...
class	ExtendedValue
	The kinds of value that a cell in a spreadsheet can have. More...
class	FilterCriteria
	Criteria for showing/hiding rows in a filter or filter view. More...
class	FilterView
	A filter view. More...
class	FindReplaceRequest
	Finds and replaces data in cells over a range, sheet, or all sheets. More...
class	FindReplaceResponse
	The result of the find/replace. More...
class	GetSpreadsheetByDataFilterRequest
	The request for retrieving a Spreadsheet. More...
class	GradientRule
	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. More...
class	GridCoordinate
	A coordinate in a sheet. All indexes are zero-based. More...
class	GridData
	Data in the grid, as well as metadata about the dimensions. More...
class	GridProperties
	Properties of a grid. More...
class	GridRange
	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. More...
class	HistogramChartSpec
	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. More...
class	HistogramRule
	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: More...
class	HistogramSeries
	A histogram series containing the series color and data. More...
class	InsertDimensionRequest
	Inserts rows or columns in a sheet at a particular index. More...
class	InsertRangeRequest
	Inserts cells into a range, shifting the existing cells over or down. More...
class	InterpolationPoint
	A single interpolation point on a gradient conditional format. These pin the gradient color scale according to the color, type and value chosen. More...
class	IterativeCalculationSettings
	Settings to control how circular dependencies are resolved with iterative calculation. More...
class	KeyValueFormat
	Formatting options for key value. More...
class	LineStyle
	Properties that describe the style of a line. More...
class	ManualRule
	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: More...
class	ManualRuleGroup
	A group name and a list of items from the source data that should be placed in the group with this name. More...
class	MatchedDeveloperMetadata
	A developer metadata entry and the data filters specified in the original request that matched it. More...
class	MatchedValueRange
	A value range that was matched by one or more data filers. More...
class	MergeCellsRequest
	Merges all cells in the range. More...
class	MoveDimensionRequest
	Moves one or more rows or columns. More...
class	NamedRange
	A named range. More...
class	NumberFormat
	The number format of a cell. More...
class	OrgChartSpec
	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. More...
class	OverlayPosition
	The location an object is overlaid on top of a grid. More...
class	Padding
	The amount of padding around the cell, in pixels. When updating padding, every field must be specified. More...
class	PasteDataRequest
	Inserts data into the spreadsheet starting at the specified coordinate. More...
class	PieChartSpec
	A pie chart. More...
class	PivotFilterCriteria
	Criteria for showing/hiding rows in a pivot table. More...
class	PivotGroup
	A single grouping (either row or column) in a pivot table. More...
class	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. 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. More...
class	PivotGroupSortValueBucket
	Information about which values in a pivot group should be used for sorting. More...
class	PivotGroupValueMetadata
	Metadata about a value in a pivot grouping. More...
class	PivotTable
	A pivot table. More...
class	PivotValue
	The definition of how a value in a pivot table should be calculated. More...
class	ProtectedRange
	A protected range. More...
class	RandomizeRangeRequest
	Randomizes the order of the rows in a range. More...
class	RepeatCellRequest
	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. More...
class	Request
	A single kind of update to apply to a spreadsheet. More...
class	Response
	A single response from an update. More...
class	RowData
	Data about each cell in a row. More...
class	ScorecardChartSpec
	A scorecard chart. Scorecard charts are used to highlight key performance indicators, known as KPIs, on the spreadsheet. A scorecard chart can represent things like total sales, average cost, or a top selling item. You can specify a single data value, or aggregate over a range of data. Percentage or absolute difference from a baseline value can be highlighted, like changes over time. More...
class	SearchDeveloperMetadataRequest
	A request to retrieve all developer metadata matching the set of specified criteria. More...
class	SearchDeveloperMetadataResponse
	A reply to a developer metadata search request. More...
class	SetBasicFilterRequest
	Sets the basic filter associated with a sheet. More...
class	SetDataValidationRequest
	Sets a data validation rule to every cell in the range. To clear validation in a range, call this with no rule specified. More...
class	Sheet
	A sheet in a spreadsheet. More...
class	SheetProperties
	Properties of a sheet. More...
class	Slicer
	A slicer in a sheet. More...
class	SlicerSpec
	The specifications of a slicer. More...
class	SortRangeRequest
	Sorts data in rows based on a sort order per column. More...
class	SortSpec
	A sort order associated with a specific column or row. More...
class	SourceAndDestination
	A combination of a source range and how to extend that source. More...
class	Spreadsheet
	Resource that represents a spreadsheet. More...
class	SpreadsheetProperties
	Properties of a spreadsheet. More...
class	SpreadsheetTheme
	Represents spreadsheet theme More...
class	TextFormat
	The format of a run of text in a cell. Absent values indicate that the field isn't specified. More...
class	TextFormatRun
	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. More...
class	TextPosition
	Position settings for text. More...
class	TextRotation
	The rotation applied to text in a cell. More...
class	TextToColumnsRequest
	Splits a column of text into multiple columns, based on a delimiter in each cell. More...
class	ThemeColorPair
	A pair mapping a spreadsheet theme color type to the concrete color it represents. More...
class	TreemapChartColorScale
	A color scale for a treemap chart. More...
class	TreemapChartSpec
	A Treemap chart. More...
class	TrimWhitespaceRequest
	Trims the whitespace (such as spaces, tabs, or new lines) in every cell in the specified range. This request removes all whitespace from the start and end of each cell's text, and reduces any subsequence of remaining whitespace characters to a single space. If the resulting trimmed text starts with a '+' or '=' character, the text remains as a string value and isn't interpreted as a formula. More...
class	TrimWhitespaceResponse
	The result of trimming whitespace in cells. More...
class	UnmergeCellsRequest
	Unmerges cells in the given range. More...
class	UpdateBandingRequest
	Updates properties of the supplied banded range. More...
class	UpdateBordersRequest
	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: More...
class	UpdateCellsRequest
	Updates all cells in a range with new data. More...
class	UpdateChartSpecRequest
	Updates a chart's specifications. (This does not move or resize a chart. To move or resize a chart, use UpdateEmbeddedObjectPositionRequest.) More...
class	UpdateConditionalFormatRuleRequest
	Updates a conditional format rule at the given index, or moves a conditional format rule to another index. More...
class	UpdateConditionalFormatRuleResponse
	The result of updating a conditional format rule. More...
class	UpdateDeveloperMetadataRequest
	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. More...
class	UpdateDeveloperMetadataResponse
	The response from updating developer metadata. More...
class	UpdateDimensionGroupRequest
	Updates the state of the specified group. More...
class	UpdateDimensionPropertiesRequest
	Updates properties of dimensions within the specified range. More...
class	UpdateEmbeddedObjectPositionRequest
	Update an embedded object's position (such as a moving or resizing a chart or image). More...
class	UpdateEmbeddedObjectPositionResponse
	The result of updating an embedded object's position. More...
class	UpdateFilterViewRequest
	Updates properties of the filter view. More...
class	UpdateNamedRangeRequest
	Updates properties of the named range with the specified namedRangeId. More...
class	UpdateProtectedRangeRequest
	Updates an existing protected range with the specified protectedRangeId. More...
class	UpdateSheetPropertiesRequest
	Updates properties of the sheet with the specified sheetId. More...
class	UpdateSlicerSpecRequest
	Updates a slicer's specifications. (This does not move or resize a slicer. To move or resize a slicer use UpdateEmbeddedObjectPositionRequest. More...
class	UpdateSpreadsheetPropertiesRequest
	Updates properties of a spreadsheet. More...
class	UpdateValuesByDataFilterResponse
	The response when updating a range of values by a data filter in a spreadsheet. More...
class	UpdateValuesResponse
	The response when updating a range of values in a spreadsheet. More...
class	ValueRange
	Data within a range of the spreadsheet. More...
class	WaterfallChartColumnStyle
	Styles for a waterfall chart column. More...
class	WaterfallChartCustomSubtotal
	A custom subtotal column for a waterfall chart series. More...
class	WaterfallChartDomain
	The domain of a waterfall chart. More...
class	WaterfallChartSeries
	A single series of data for a waterfall chart. More...
class	WaterfallChartSpec
	A waterfall chart. More...