Description Usage Arguments Details Value
Request Object
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)
|
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 |
Autogenerated via gar_create_api_objects
A single kind of update to apply to a spreadsheet.
Request object
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.