Delete Range
Deletes a range of cells, shifting other cells into the deleted area.
Inputs
|
In
Exec
|
|
|
In Token
Google Sheets Web Token Object Reference
|
A validated UGoogleSheetsWebToken object. Used to authenticate the Sheets operation. |
|
Operation Params
Google Sheets Operation Params Structure
|
Generic request operation parameters |
|
Call on Complete
Delegate (by ref)
|
This delegate will be called when the operation completes and tell you whether or not it was successful and return the response as a UGoogleSheetsObjectSheet Tab Data Object. |
|
In Spreadsheet Id
String
|
This is the spreadsheet ID number or key. Get it from your spreadsheet URL by calling GetSpreadsheetIdFromUrl. |
|
Specific Sheet Id
Integer
|
The ID number or GID of the sheet tab. If blank or negative, this operation will affect the entire spreadsheet on every sheet tab. |
|
Specific Range
String
|
A single range, expressed in A1 notation, that you wish to retrieve. Call GetRangeInA1NotationFromColumnAndRowIndices passing in 1-based indices. |
|
Shift Dimension
EGoogleSheetsMajorDimension Enum
|
The dimension from which deleted cells will be replaced with. If ROWS, existing cells will be shifted upward to replace the deleted cells. If COLUMNS, existing cells will be shifted left to replace the deleted cells. |
Outputs
|
Out
Exec
|