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 reference]

Parameters

Parameter

Label

Required

Options

Description

Range

YES

TabName

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

Option	Value
FORMATTED_VALUE	FORMATTED_VALUE
UNFORMATTED_VALUE	UNFORMATTED_VALUE
FORMULA	FORMULA

valueInputOption

Option	Value
USER_ENTERED	USER_ENTERED
RAW	RAW

majorDimension

Option	Value
DIMENSION_UNSPECIFIED	DIMENSION_UNSPECIFIED
COLUMNS	COLUMNS
ROWS	ROWS

dateTimeRenderOption

Option	Value
SERIAL_NUMBER	SERIAL_NUMBER
FORMATTED_STRING	FORMATTED_STRING

SpreadSheetId

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	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
spreadsheetId	`DT_WSTR`	`nvarchar(100)`	100	`False`
clearedRange	`DT_WSTR`	`nvarchar(255)`	255	`False`

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Google Sheets Connector in API Source component to read data or in API Destination component to read/write data:

Clear Sheet Values using API Source

Google Sheets

Clear Sheet Values

SSIS API Source - Read from table or endpoint

Clear Sheet Values using API Destination

Google Sheets

Clear Sheet Values