Request: Request Object

Description Usage Arguments Details Value

Description

Request Object

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Request(addConditionalFormatRule = NULL, addNamedRange = NULL,
  updateCells = NULL, updateSpreadsheetProperties = NULL,
  deleteEmbeddedObject = NULL, updateFilterView = NULL, addBanding = NULL,
  autoResizeDimensions = NULL, appendCells = NULL, cutPaste = NULL,
  mergeCells = NULL, updateNamedRange = NULL,
  updateSheetProperties = NULL, autoFill = NULL, deleteDimension = NULL,
  sortRange = NULL, deleteDimensionGroup = NULL,
  deleteProtectedRange = NULL, duplicateFilterView = NULL,
  addChart = NULL, findReplace = NULL, updateChartSpec = NULL,
  textToColumns = NULL, updateProtectedRange = NULL, addSheet = NULL,
  copyPaste = NULL, deleteFilterView = NULL, insertDimension = NULL,
  deleteRange = NULL, deleteBanding = NULL, addFilterView = NULL,
  setDataValidation = NULL, updateBorders = NULL,
  deleteConditionalFormatRule = NULL, clearBasicFilter = NULL,
  repeatCell = NULL, appendDimension = NULL,
  createDeveloperMetadata = NULL, updateConditionalFormatRule = NULL,
  insertRange = NULL, deleteDeveloperMetadata = NULL,
  moveDimension = NULL, randomizeRange = NULL, updateBanding = NULL,
  deleteNamedRange = NULL, addProtectedRange = NULL,
  duplicateSheet = NULL, unmergeCells = NULL, deleteSheet = NULL,
  updateEmbeddedObjectPosition = NULL, addDimensionGroup = NULL,
  updateDeveloperMetadata = NULL, updateDimensionProperties = NULL,
  updateDimensionGroup = NULL, pasteData = NULL, setBasicFilter = NULL)

Arguments

addConditionalFormatRule

Adds a new conditional format rule

addNamedRange

Adds a named range

updateCells

Updates many cells at once

updateSpreadsheetProperties

Updates the spreadsheet's properties

deleteEmbeddedObject

Deletes an embedded object (e

updateFilterView

Updates the properties of a filter view

addBanding

Adds a new banded range

autoResizeDimensions

Automatically resizes one or more dimensions based on the contents

appendCells

Appends cells after the last row with data in a sheet

cutPaste

Cuts data from one area and pastes it to another

mergeCells

Merges cells together

updateNamedRange

Updates a named range

updateSheetProperties

Updates a sheet's properties

autoFill

Automatically fills in more data based on existing data

deleteDimension

Deletes rows or columns in a sheet

sortRange

Sorts data in a range

deleteDimensionGroup

Deletes a group over the specified range

deleteProtectedRange

Deletes a protected range

duplicateFilterView

Duplicates a filter view

addChart

Adds a chart

findReplace

Finds and replaces occurrences of some text with other text

updateChartSpec

Updates a chart's specifications

textToColumns

Converts a column of text into many columns of text

updateProtectedRange

Updates a protected range

addSheet

Adds a sheet

copyPaste

Copies data from one area and pastes it to another

deleteFilterView

Deletes a filter view from a sheet

insertDimension

Inserts new rows or columns in a sheet

deleteRange

Deletes a range of cells from a sheet, shifting the remaining cells

deleteBanding

Removes a banded range

addFilterView

Adds a filter view

setDataValidation

Sets data validation for one or more cells

updateBorders

Updates the borders in a range of cells

deleteConditionalFormatRule

Deletes an existing conditional format rule

clearBasicFilter

Clears the basic filter on a sheet

repeatCell

Repeats a single cell across a range

appendDimension

Appends dimensions to the end of a sheet

createDeveloperMetadata

Creates new developer metadata

updateConditionalFormatRule

Updates an existing conditional format rule

insertRange

Inserts new cells in a sheet, shifting the existing cells

deleteDeveloperMetadata

Deletes developer metadata

moveDimension

Moves rows or columns to another location in a sheet

randomizeRange

Randomizes the order of the rows in a range

updateBanding

Updates a banded range

deleteNamedRange

Deletes a named range

addProtectedRange

Adds a protected range

duplicateSheet

Duplicates a sheet

unmergeCells

Unmerges merged cells

deleteSheet

Deletes a sheet

updateEmbeddedObjectPosition

Updates an embedded object's (e

addDimensionGroup

Creates a group over the specified range

updateDeveloperMetadata

Updates an existing developer metadata entry

updateDimensionProperties

Updates dimensions' properties

updateDimensionGroup

Updates the state of the specified group

pasteData

Pastes data (HTML or delimited) into a sheet

setBasicFilter

Sets the basic filter on a sheet

Details

Autogenerated via gar_create_api_objects A single kind of update to apply to a spreadsheet.

Value

Request object


lantanacamara/googleSheetsR documentation built on May 3, 2019, 11:52 p.m.