Package | Description |
---|---|
com.google.api.services.sheets.v4.model |
Modifier and Type | Method and Description |
---|---|
Request |
Request.clone() |
Request |
Request.set(String fieldName,
Object value) |
Request |
Request.setAddBanding(AddBandingRequest addBanding)
Adds a new banded range
|
Request |
Request.setAddChart(AddChartRequest addChart)
Adds a chart.
|
Request |
Request.setAddConditionalFormatRule(AddConditionalFormatRuleRequest addConditionalFormatRule)
Adds a new conditional format rule.
|
Request |
Request.setAddDataSource(AddDataSourceRequest addDataSource)
Adds a data source.
|
Request |
Request.setAddDimensionGroup(AddDimensionGroupRequest addDimensionGroup)
Creates a group over the specified range.
|
Request |
Request.setAddFilterView(AddFilterViewRequest addFilterView)
Adds a filter view.
|
Request |
Request.setAddNamedRange(AddNamedRangeRequest addNamedRange)
Adds a named range.
|
Request |
Request.setAddProtectedRange(AddProtectedRangeRequest addProtectedRange)
Adds a protected range.
|
Request |
Request.setAddSheet(AddSheetRequest addSheet)
Adds a sheet.
|
Request |
Request.setAddSlicer(AddSlicerRequest addSlicer)
Adds a slicer.
|
Request |
Request.setAppendCells(AppendCellsRequest appendCells)
Appends cells after the last row with data in a sheet.
|
Request |
Request.setAppendDimension(AppendDimensionRequest appendDimension)
Appends dimensions to the end of a sheet.
|
Request |
Request.setAutoFill(AutoFillRequest autoFill)
Automatically fills in more data based on existing data.
|
Request |
Request.setAutoResizeDimensions(AutoResizeDimensionsRequest autoResizeDimensions)
Automatically resizes one or more dimensions based on the contents of the cells in that
dimension.
|
Request |
Request.setCancelDataSourceRefresh(CancelDataSourceRefreshRequest cancelDataSourceRefresh)
Cancels refreshes of one or multiple data sources and associated dbobjects.
|
Request |
Request.setClearBasicFilter(ClearBasicFilterRequest clearBasicFilter)
Clears the basic filter on a sheet.
|
Request |
Request.setCopyPaste(CopyPasteRequest copyPaste)
Copies data from one area and pastes it to another.
|
Request |
Request.setCreateDeveloperMetadata(CreateDeveloperMetadataRequest createDeveloperMetadata)
Creates new developer metadata
|
Request |
Request.setCutPaste(CutPasteRequest cutPaste)
Cuts data from one area and pastes it to another.
|
Request |
Request.setDeleteBanding(DeleteBandingRequest deleteBanding)
Removes a banded range
|
Request |
Request.setDeleteConditionalFormatRule(DeleteConditionalFormatRuleRequest deleteConditionalFormatRule)
Deletes an existing conditional format rule.
|
Request |
Request.setDeleteDataSource(DeleteDataSourceRequest deleteDataSource)
Deletes a data source.
|
Request |
Request.setDeleteDeveloperMetadata(DeleteDeveloperMetadataRequest deleteDeveloperMetadata)
Deletes developer metadata
|
Request |
Request.setDeleteDimension(DeleteDimensionRequest deleteDimension)
Deletes rows or columns in a sheet.
|
Request |
Request.setDeleteDimensionGroup(DeleteDimensionGroupRequest deleteDimensionGroup)
Deletes a group over the specified range.
|
Request |
Request.setDeleteDuplicates(DeleteDuplicatesRequest deleteDuplicates)
Removes rows containing duplicate values in specified columns of a cell range.
|
Request |
Request.setDeleteEmbeddedObject(DeleteEmbeddedObjectRequest deleteEmbeddedObject)
Deletes an embedded object (e.g, chart, image) in a sheet.
|
Request |
Request.setDeleteFilterView(DeleteFilterViewRequest deleteFilterView)
Deletes a filter view from a sheet.
|
Request |
Request.setDeleteNamedRange(DeleteNamedRangeRequest deleteNamedRange)
Deletes a named range.
|
Request |
Request.setDeleteProtectedRange(DeleteProtectedRangeRequest deleteProtectedRange)
Deletes a protected range.
|
Request |
Request.setDeleteRange(DeleteRangeRequest deleteRange)
Deletes a range of cells from a sheet, shifting the remaining cells.
|
Request |
Request.setDeleteSheet(DeleteSheetRequest deleteSheet)
Deletes a sheet.
|
Request |
Request.setDuplicateFilterView(DuplicateFilterViewRequest duplicateFilterView)
Duplicates a filter view.
|
Request |
Request.setDuplicateSheet(DuplicateSheetRequest duplicateSheet)
Duplicates a sheet.
|
Request |
Request.setFindReplace(FindReplaceRequest findReplace)
Finds and replaces occurrences of some text with other text.
|
Request |
Request.setInsertDimension(InsertDimensionRequest insertDimension)
Inserts new rows or columns in a sheet.
|
Request |
Request.setInsertRange(InsertRangeRequest insertRange)
Inserts new cells in a sheet, shifting the existing cells.
|
Request |
Request.setMergeCells(MergeCellsRequest mergeCells)
Merges cells together.
|
Request |
Request.setMoveDimension(MoveDimensionRequest moveDimension)
Moves rows or columns to another location in a sheet.
|
Request |
Request.setPasteData(PasteDataRequest pasteData)
Pastes data (HTML or delimited) into a sheet.
|
Request |
Request.setRandomizeRange(RandomizeRangeRequest randomizeRange)
Randomizes the order of the rows in a range.
|
Request |
Request.setRefreshDataSource(RefreshDataSourceRequest refreshDataSource)
Refreshes one or multiple data sources and associated dbobjects.
|
Request |
Request.setRepeatCell(RepeatCellRequest repeatCell)
Repeats a single cell across a range.
|
Request |
Request.setSetBasicFilter(SetBasicFilterRequest setBasicFilter)
Sets the basic filter on a sheet.
|
Request |
Request.setSetDataValidation(SetDataValidationRequest setDataValidation)
Sets data validation for one or more cells.
|
Request |
Request.setSortRange(SortRangeRequest sortRange)
Sorts data in a range.
|
Request |
Request.setTextToColumns(TextToColumnsRequest textToColumns)
Converts a column of text into many columns of text.
|
Request |
Request.setTrimWhitespace(TrimWhitespaceRequest trimWhitespace)
Trims cells of whitespace (such as spaces, tabs, or new lines).
|
Request |
Request.setUnmergeCells(UnmergeCellsRequest unmergeCells)
Unmerges merged cells.
|
Request |
Request.setUpdateBanding(UpdateBandingRequest updateBanding)
Updates a banded range
|
Request |
Request.setUpdateBorders(UpdateBordersRequest updateBorders)
Updates the borders in a range of cells.
|
Request |
Request.setUpdateCells(UpdateCellsRequest updateCells)
Updates many cells at once.
|
Request |
Request.setUpdateChartSpec(UpdateChartSpecRequest updateChartSpec)
Updates a chart's specifications.
|
Request |
Request.setUpdateConditionalFormatRule(UpdateConditionalFormatRuleRequest updateConditionalFormatRule)
Updates an existing conditional format rule.
|
Request |
Request.setUpdateDataSource(UpdateDataSourceRequest updateDataSource)
Updates a data source.
|
Request |
Request.setUpdateDeveloperMetadata(UpdateDeveloperMetadataRequest updateDeveloperMetadata)
Updates an existing developer metadata entry
|
Request |
Request.setUpdateDimensionGroup(UpdateDimensionGroupRequest updateDimensionGroup)
Updates the state of the specified group.
|
Request |
Request.setUpdateDimensionProperties(UpdateDimensionPropertiesRequest updateDimensionProperties)
Updates dimensions' properties.
|
Request |
Request.setUpdateEmbeddedObjectBorder(UpdateEmbeddedObjectBorderRequest updateEmbeddedObjectBorder)
Updates an embedded object's border.
|
Request |
Request.setUpdateEmbeddedObjectPosition(UpdateEmbeddedObjectPositionRequest updateEmbeddedObjectPosition)
Updates an embedded object's (e.g.
|
Request |
Request.setUpdateFilterView(UpdateFilterViewRequest updateFilterView)
Updates the properties of a filter view.
|
Request |
Request.setUpdateNamedRange(UpdateNamedRangeRequest updateNamedRange)
Updates a named range.
|
Request |
Request.setUpdateProtectedRange(UpdateProtectedRangeRequest updateProtectedRange)
Updates a protected range.
|
Request |
Request.setUpdateSheetProperties(UpdateSheetPropertiesRequest updateSheetProperties)
Updates a sheet's properties.
|
Request |
Request.setUpdateSlicerSpec(UpdateSlicerSpecRequest updateSlicerSpec)
Updates a slicer's specifications.
|
Request |
Request.setUpdateSpreadsheetProperties(UpdateSpreadsheetPropertiesRequest updateSpreadsheetProperties)
Updates the spreadsheet's properties.
|
Modifier and Type | Method and Description |
---|---|
List<Request> |
BatchUpdateSpreadsheetRequest.getRequests()
A list of updates to apply to the spreadsheet.
|
Modifier and Type | Method and Description |
---|---|
BatchUpdateSpreadsheetRequest |
BatchUpdateSpreadsheetRequest.setRequests(List<Request> requests)
A list of updates to apply to the spreadsheet.
|
Copyright © 2011–2024 Google. All rights reserved.