Specifies the file storage service, server, or file access protocol through which your Microsoft Excel files are stored and retreived.

Possible Values

Auto, Local, Amazon S3, Azure Blob Storage, Azure Data Lake Storage Gen1, Azure Data Lake Storage Gen2, Azure Data Lake Storage Gen2 SSL, Azure Files, Box, Dropbox, FTP, FTPS, Google Cloud Storage, Google Drive, HDFS, HDFS Secure, HTTP, HTTPS, IBM Object Storage Source, OneDrive, Oracle Cloud Storage, SFTP, SharePoint REST, SharePoint SOAP

Data Type

string

Default Value

"Auto"

Remarks

Set the ConnectionType to one of the following:

• Auto: The provider infers the connection type from the syntax of the provided URI.
• Local: Microsoft Excel files stored on your local machine.
• Amazon S3
• Azure Blob Storage
• Azure Data Lake Storage Gen1
• Azure Data Lake Storage Gen2
• Azure Data Lake Storage Gen2 SSL
• Azure Files
• Box
• Dropbox
• FTP
• FTPS
• Google Cloud Storage
• Google Drive
• HDFS
• HDFS Secure
• HTTP: Connects to Microsoft Excel files hosted on HTTP streams.
• HTTPS: Connects to Microsoft Excel files hosted on HTTPS streams.
• IBM Object Storage Source
• OneDrive
• Oracle Cloud Storage
• SFTP
• SharePoint REST
• SharePoint SOAP