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

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

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

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`

If the column you are looking for is missing, consider customizing Google Sheets Connector.

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:

Delete Sheet Rows / Columns using API Source

Google Sheets

Delete Sheet Rows / Columns

SSIS API Source - Read from table or endpoint

Delete Sheet Rows / Columns using API Destination

Google Sheets

Delete Sheet Rows / Columns

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Delete sheet rows / columns

SELECT * FROM delete_sheet_rows_columns
WITH
(
    "Dimension" = 'ROWS',
    "StartIndex" = '0',
    "EndIndex" = '1',
    "TabId" = '0'
)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Delete sheet rows / columns

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_sheet_rows_columns
WITH
(
    "Dimension" = ''ROWS'',
    "StartIndex" = ''0'',
    "EndIndex" = ''1'',
    "TabId" = ''0''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_SHEETS_IN_GATEWAY];