EndPoint Delete Sheet Rows / Columns
Name
delete_sheet_rows_columns
Description
Deletes rows / columns based on startIndex / endIndex range (Index is zero based). For example to delete First 5 rows specify startIndex=0 and endIndex=4
[API Help]
Parameters
| Parameter |
Label |
Required |
Options |
Description |
| Dimension |
Range Type |
YES |
| Option |
Value |
| ROWS |
ROWS |
| COLUMNS |
COLUMNS |
|
Specifies what would you like to delete (i.e. Rows or Columns)
|
| StartIndex |
Range Start Index (starts from 0) |
YES |
|
Range Start Index (Zero based) for operation. For Column Operation translate Alpha value to zero based index. Example: Column D = Index 3. Column AA=26
|
| EndIndex |
Range End Index (starts from 0) |
YES |
|
Range End Index (Zero based) for operation. For Column Operation translate Alpha value to zero based index. Example: Column D = Index 3. Column AA=26
|
| TabId |
TabId |
YES |
|
Numeric ID of SpreadSheet Tab for which you like to delete rows/columns. For first tab its 0. You can find this ID from Sheet URL in browser. Get Number after edit#gid= (thats your Tab ID)
|
| SpreadSheetId |
SpreadSheetId |
NO |
| Option |
Value |
| Enter Your Sheet Id |
|
| Example Sheet Id |
1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
|
Enter unique spreadsheet Id. To obtain sheet Id. Open spreadsheet in browser and check URL. You will example value like 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms that is your sheet id.
|
Output Columns
| Label |
DataType |
Length |
Raw |
Description |
| spreadsheetId |
DT_WSTR |
100 |
False |
|
Input Columns
| Label |
DataType |
Length |
Raw |
Description |
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |
