EndPoint Clear Sheet Values
Name
clear_sheet_range
Description
Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept.
[API Help]
Parameters
| Parameter |
Label |
Required |
Options |
Description |
| Range |
Range |
YES |
|
|
| TabName |
TabName |
NO |
|
If you have multiple tabs on your spreadsheet then you can specify here. By default first tab is used if you do not enter.
|
| valueRenderOption |
valueRenderOption |
NO |
| Option |
Value |
| FORMATTED_VALUE |
FORMATTED_VALUE |
| UNFORMATTED_VALUE |
UNFORMATTED_VALUE |
| FORMULA |
FORMULA |
|
|
| valueInputOption |
valueInputOption |
NO |
| Option |
Value |
| USER_ENTERED |
USER_ENTERED |
| RAW |
RAW |
|
|
| majorDimension |
majorDimension |
NO |
| Option |
Value |
| DIMENSION_UNSPECIFIED |
DIMENSION_UNSPECIFIED |
| COLUMNS |
COLUMNS |
| ROWS |
ROWS |
|
|
| dateTimeRenderOption |
dateTimeRenderOption |
NO |
| Option |
Value |
| SERIAL_NUMBER |
SERIAL_NUMBER |
| FORMATTED_STRING |
FORMATTED_STRING |
|
|
| 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 |
|
| clearedRange |
DT_WSTR |
255 |
False |
|
Input Columns
| Label |
DataType |
Length |
Raw |
Description |
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |
