JDBC Driver for Google Sheets

Build 20.0.7587

Columns

You can specify column names or generate column names automatically by setting the Header property. This property affects how you use columns in commands.

Header=True (Default)

  • Columns are determined by the first row of the Google spreadsheet. If no values are provided for the first row of the spreadsheet, the driver will create unique, alphabetized column names that are available only within the scope of that request.
  • The driver also adds an Id column for each row that corresponds to the unique URI of the row on the Google servers. This is used during update and delete operations.

Header=False

  • Columns will be dynamically assigned based on either the specified range or the size of the worksheet. The autogenerated column names are alphabetical.
  • The Id column for each row will represent the row number from the top of the sheet. For example, if you specify a range A3:E6, rows 3, 4, 5, and 6 will be returned.

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