EndPoint Update Sheet Data (Overwrite Cells)

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

update_sheet_data

Description

Update data to spreadsheet on desired tab / cell location (i.e. start/end range) [API reference]

Parameters

Parameter

Label

Required

Options

Description

Range

Range for Table Boundary (Including Header)

YES

Enter Range to detect Table column names and datatypes. Example: enter A1:C if you have table of 3 columns starting from Cell A1

WriteRange

Range for Data Cells

YES

Cell Range which needs to be update. Example: Enter A2 if you like to start update from cell A2

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
spreadsheetId	`DT_WSTR`	`nvarchar(100)`	100	False
updatedRange	`DT_WSTR`	`nvarchar(255)`	255	False
updatedRows	`DT_I4`	`int`		False
updatedColumns	`DT_I4`	`int`		False
updatedCells	`DT_I4`	`int`		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.