Connection
This section provides a complete list of the Connection properties you can configure in the connection string for this provider.
| Property | Description |
| Spreadsheet | A comma-separated list of the names or Ids of the spreadsheets to be viewed. |
| FolderName | A comma separated list of the folders' names from which to retrieve spreadsheets in the format FolderName='name1,name2'. |
| FolderId | A comma separated list of the folders' ids from which to retrieve spreadsheets in the format FolderId='id1,id2,id3'. |
| ShowTrashedFiles | Indicates whether or not the trashed files will be listed. |
| TeamDriveSupport | Determines whether or not to retrieve Team Drive items. |
| UseIdAsTableName | Indicates whether or not to use Ids as Spreadsheet and Sheet name. |
| TeamDrive | A drive's names or ids from which to retrieve spreadsheets in the format TeamDrive='Shared drive 2, Shared drive 3', or TeamDrive='0BKwyFj1j9FOsUk9EVO, 0ANMIP9RIe1LQUk9PVA'. |
| DomainSharedFilesOnly | Boolean determining if the exposed sheets are limited to only the sheets shared to the user's domain or not. |
| RecurseFolders | Used in case FolderId/FolderName properties are defined. If set to True this makes the driver return all the Spreadsheets inside nested folders, else the driver will return only the files directly to that foder. By default this is set to false. |
| IgnoreErrorValues | When reading the data, we throw an exception or ignore the formula error based on IgnoreErrorValues=True/False. |