JDBC Driver for Google Sheets

Build 22.0.8462

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 Boolean True if the grid is not showing gridlines in the UI.
Hidden Boolean True if the sheet is hidden in the UI, false if it is visible.
RightToLeft Boolean True if the sheet is an RTL sheet instead of an LTR sheet.

Result Set Columns

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462