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 add-in will create unique, alphabetized column names that are available only within the scope of that request.
- The add-in 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.