Columns

Columns are determined by the first row of the Google spreadsheet. This notation is derived from the RSSBus ADO.NET Provider for Google Spreadsheets API documentation. If no values are provided for the first row of the Spreadsheet, the provider will derive unique column names that are available only for the scope of that request. The naming of these auto-generated columns cannot be used across queries or connections.

The provider also adds an Id column for each row that corresponds to the unique URI of the row on the Google servers. This Id column is used during Update and Delete operations.