Package | Description |
---|---|
com.google.api.services.sheets.v4.model |
Modifier and Type | Method and Description |
---|---|
GridRange |
GridRange.clone() |
GridRange |
SlicerSpec.getDataRange()
The data range of the slicer.
|
GridRange |
CopyPasteRequest.getDestination()
The location to paste to.
|
GridRange |
DataFilter.getGridRange()
Selects data that matches the range described by the GridRange.
|
GridRange |
UpdateCellsRequest.getRange()
The range to write data to.
|
GridRange |
BandedRange.getRange()
The range over which these properties are applied.
|
GridRange |
InsertRangeRequest.getRange()
The range to insert new cells into.
|
GridRange |
SetDataValidationRequest.getRange()
The range the data validation rule should apply to.
|
GridRange |
UnmergeCellsRequest.getRange()
The range within which all cells should be unmerged.
|
GridRange |
DeleteDuplicatesRequest.getRange()
The range to remove duplicates rows from.
|
GridRange |
FilterView.getRange()
The range this filter view covers.
|
GridRange |
MergeCellsRequest.getRange()
The range of cells to merge.
|
GridRange |
RandomizeRangeRequest.getRange()
The range to randomize.
|
GridRange |
SortRangeRequest.getRange()
The range to sort.
|
GridRange |
RepeatCellRequest.getRange()
The range to repeat the cell in.
|
GridRange |
DataSourceParameter.getRange()
A range that contains the value of the parameter.
|
GridRange |
FindReplaceRequest.getRange()
The range to find/replace over.
|
GridRange |
NamedRange.getRange()
The range this represents.
|
GridRange |
ProtectedRange.getRange()
The range that is being protected.
|
GridRange |
UpdateBordersRequest.getRange()
The range whose borders should be updated.
|
GridRange |
BasicFilter.getRange()
The range the filter covers.
|
GridRange |
TrimWhitespaceRequest.getRange()
The range whose cells to trim.
|
GridRange |
DeleteRangeRequest.getRange()
The range of cells to delete.
|
GridRange |
AutoFillRequest.getRange()
The range to autofill.
|
GridRange |
CopyPasteRequest.getSource()
The source range to copy.
|
GridRange |
SourceAndDestination.getSource()
The location of the data to use as the source of the autofill.
|
GridRange |
PivotTable.getSource()
The range the pivot table is reading data from.
|
GridRange |
TextToColumnsRequest.getSource()
The source data range.
|
GridRange |
CutPasteRequest.getSource()
The source data to cut.
|
GridRange |
GridRange.set(String fieldName,
Object value) |
GridRange |
GridRange.setEndColumnIndex(Integer endColumnIndex)
The end column (exclusive) of the range, or not set if unbounded.
|
GridRange |
GridRange.setEndRowIndex(Integer endRowIndex)
The end row (exclusive) of the range, or not set if unbounded.
|
GridRange |
GridRange.setSheetId(Integer sheetId)
The sheet this range is on.
|
GridRange |
GridRange.setStartColumnIndex(Integer startColumnIndex)
The start column (inclusive) of the range, or not set if unbounded.
|
GridRange |
GridRange.setStartRowIndex(Integer startRowIndex)
The start row (inclusive) of the range, or not set if unbounded.
|
Modifier and Type | Method and Description |
---|---|
List<GridRange> |
Sheet.getMerges()
The ranges that are merged together.
|
List<GridRange> |
ConditionalFormatRule.getRanges()
The ranges that are formatted if the condition is true.
|
List<GridRange> |
ChartSourceRange.getSources()
The ranges of data for a series or domain.
|
List<GridRange> |
ProtectedRange.getUnprotectedRanges()
The list of unprotected ranges within a protected sheet.
|
Modifier and Type | Method and Description |
---|---|
SlicerSpec |
SlicerSpec.setDataRange(GridRange dataRange)
The data range of the slicer.
|
CopyPasteRequest |
CopyPasteRequest.setDestination(GridRange destination)
The location to paste to.
|
DataFilter |
DataFilter.setGridRange(GridRange gridRange)
Selects data that matches the range described by the GridRange.
|
UpdateCellsRequest |
UpdateCellsRequest.setRange(GridRange range)
The range to write data to.
|
BandedRange |
BandedRange.setRange(GridRange range)
The range over which these properties are applied.
|
InsertRangeRequest |
InsertRangeRequest.setRange(GridRange range)
The range to insert new cells into.
|
SetDataValidationRequest |
SetDataValidationRequest.setRange(GridRange range)
The range the data validation rule should apply to.
|
UnmergeCellsRequest |
UnmergeCellsRequest.setRange(GridRange range)
The range within which all cells should be unmerged.
|
DeleteDuplicatesRequest |
DeleteDuplicatesRequest.setRange(GridRange range)
The range to remove duplicates rows from.
|
FilterView |
FilterView.setRange(GridRange range)
The range this filter view covers.
|
MergeCellsRequest |
MergeCellsRequest.setRange(GridRange range)
The range of cells to merge.
|
RandomizeRangeRequest |
RandomizeRangeRequest.setRange(GridRange range)
The range to randomize.
|
SortRangeRequest |
SortRangeRequest.setRange(GridRange range)
The range to sort.
|
RepeatCellRequest |
RepeatCellRequest.setRange(GridRange range)
The range to repeat the cell in.
|
DataSourceParameter |
DataSourceParameter.setRange(GridRange range)
A range that contains the value of the parameter.
|
FindReplaceRequest |
FindReplaceRequest.setRange(GridRange range)
The range to find/replace over.
|
NamedRange |
NamedRange.setRange(GridRange range)
The range this represents.
|
ProtectedRange |
ProtectedRange.setRange(GridRange range)
The range that is being protected.
|
UpdateBordersRequest |
UpdateBordersRequest.setRange(GridRange range)
The range whose borders should be updated.
|
BasicFilter |
BasicFilter.setRange(GridRange range)
The range the filter covers.
|
TrimWhitespaceRequest |
TrimWhitespaceRequest.setRange(GridRange range)
The range whose cells to trim.
|
DeleteRangeRequest |
DeleteRangeRequest.setRange(GridRange range)
The range of cells to delete.
|
AutoFillRequest |
AutoFillRequest.setRange(GridRange range)
The range to autofill.
|
CopyPasteRequest |
CopyPasteRequest.setSource(GridRange source)
The source range to copy.
|
SourceAndDestination |
SourceAndDestination.setSource(GridRange source)
The location of the data to use as the source of the autofill.
|
PivotTable |
PivotTable.setSource(GridRange source)
The range the pivot table is reading data from.
|
TextToColumnsRequest |
TextToColumnsRequest.setSource(GridRange source)
The source data range.
|
CutPasteRequest |
CutPasteRequest.setSource(GridRange source)
The source data to cut.
|
Modifier and Type | Method and Description |
---|---|
Sheet |
Sheet.setMerges(List<GridRange> merges)
The ranges that are merged together.
|
ConditionalFormatRule |
ConditionalFormatRule.setRanges(List<GridRange> ranges)
The ranges that are formatted if the condition is true.
|
ChartSourceRange |
ChartSourceRange.setSources(List<GridRange> sources)
The ranges of data for a series or domain.
|
ProtectedRange |
ProtectedRange.setUnprotectedRanges(List<GridRange> unprotectedRanges)
The list of unprotected ranges within a protected sheet.
|
Copyright © 2011–2024 Google. All rights reserved.