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
24
25
Request(updateSpreadsheetProperties = NULL,
  deleteEmbeddedObject = NULL, updateFilterView = NULL,
  addBanding = NULL, appendCells = NULL, autoResizeDimensions = NULL,
  cutPaste = NULL, mergeCells = NULL, updateNamedRange = NULL,
  updateSheetProperties = NULL, autoFill = NULL,
  deleteDimension = NULL, sortRange = NULL,
  deleteProtectedRange = NULL, deleteDimensionGroup = NULL,
  duplicateFilterView = NULL, addChart = NULL, findReplace = NULL,
  updateChartSpec = NULL, textToColumns = NULL,
  updateProtectedRange = NULL, addSheet = NULL,
  deleteFilterView = NULL, copyPaste = NULL, insertDimension = NULL,
  deleteRange = NULL, deleteBanding = NULL, addFilterView = NULL,
  updateBorders = NULL, setDataValidation = 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,
  updateDimensionProperties = NULL, updateDeveloperMetadata = NULL,
  pasteData = NULL, updateDimensionGroup = NULL,
  setBasicFilter = NULL, addConditionalFormatRule = NULL,
  addNamedRange = NULL, updateCells = NULL)

Arguments

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

appendCells

Appends cells after the last row with data in a sheet

autoResizeDimensions

Automatically resizes one or more dimensions based on the contents

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

deleteProtectedRange

Deletes a protected range

deleteDimensionGroup

Deletes a group over the specified 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

deleteFilterView

Deletes a filter view from a sheet

copyPaste

Copies data from one area and pastes it to another

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

updateBorders

Updates the borders in a range of cells

setDataValidation

Sets data validation for one or more 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

updateDimensionProperties

Updates dimensions' properties

updateDeveloperMetadata

Updates an existing developer metadata entry

pasteData

Pastes data (HTML or delimited) into a sheet

updateDimensionGroup

Updates the state of the specified group

setBasicFilter

Sets the basic filter on a sheet

addConditionalFormatRule

Adds a new conditional format rule

addNamedRange

Adds a named range

updateCells

Updates many cells at once

Details

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

Value

Request object


bradgwest/googleSheetsR documentation built on May 16, 2019, 3:07 p.m.