JDBC Driver for Google Sheets

Build 20.0.7587

AddSheet

Add a worksheet to an existing Google spreadsheet.

Input

Name Type Description
SpreadsheetId String The ID of the spreadsheet.
SheetId String The ID of the sheet. Must be non-negative. This field cannot be changed once set.
Title String The name of the sheet.
Index String The index of the sheet within the spreadsheet.
SheetType String The type of sheet. Defaults to GRID. This field cannot be changed once set.

The allowed values are GRID, OBJECT.

The default value is GRID.

RowCount String The number of rows in the grid.
ColumnCount String The number of columns in the grid.
FrozenRowCount String The number of rows that are frozen in the grid.
FrozenColumnCount String The number of columns that are frozen in the grid.
HideGridlines String True if the grid is not showing gridlines in the UI.

The allowed values are true, false.

Hidden String True if the sheet is hidden in the UI, false if it is visible.

The allowed values are true, false.

RightToLeft String True if the sheet is an RTL sheet instead of an LTR sheet.

The allowed values are true, false.

Result Set Columns

Name Type Description
Success String This value shows whether the operation was successful or not.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587