EndPoint Create SpreadSheet Tab

Contents

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

Name

create_sheet_tab

Description

Creates new tab for specified spreadsheet. [API reference]

Parameters

Parameter

Label

Required

Options

Description

NewTabName

YES

Name for new Tab you like to add

InitialRowCount

YES

Initial row count for new sheet

InitialColumnCount

YES

Initial column count for new sheet

TabColorRedValue

YES

Tab Color - Red Value for RGB

TabColorGreenValue

YES

Tab Color - Green Value for RGB

TabColorBlueValue

YES

Tab Color - Blue Value for RGB

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

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.