URI
The Uniform Resource Identifier (URI) for the Excel resource location.
Data Type
string
Default Value
""
Remarks
Set the URI property to specify a path to a file or stream.
A comma-separated list of URIs is supported to include multiple files. See for more advanced features available for parsing and merging multiple files.
Below are examples of the URI formats for the available data sources:
| Service provider | URI formats | |
| Local | localPath
file://localPath | |
| HTTP or HTTPS | http://remoteStream
https://remoteStream | |
| Amazon S3 | s3://remotePath | |
| Google Drive | gdrive://remotePath | |
| Box | box://remotePath | |
| FTP or FTPS | ftp://server:port/remotePath
ftps://server:port/remotepath | |
| SFTP | sftp://server:port/remotePath | |
| Sharepoint | sp://https://server/remotePath |
Example Connection Strings and Queries
Below are example connection strings to Excel files or streams.
| Service provider | URI formats | Connection example | Query example (if folder1 contains file1.Excel or streamname1 is a Excel stream) |
| Local | localPath
file://localPath | URI=C:\folder1 | SELECT * FROM file1 |
| HTTP or HTTPS | http://remoteStream
https://remoteStream | URI=http://www.host1.com/streamname1; | SELECT * FROM streamedtable |
| Amazon S3 | s3://bucket1/folder1 | URI=s3://bucket1/folder1; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO; | SELECT * FROM file1 |
| Google Drive | gdrive://remotePath | URI=gdrive://folder1;InitiateOAuth=GETANDREFRESH; | SELECT * FROM file1 |
| Box | box://remotePath | URI=box://folder1; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345; | SELECT * FROM file1 |
| FTP or FTPS | ftp://server:port/remotePath
ftps://server:port/remotepath | URI=ftps://localhost:990/folder1; User=user1; Password=password1; | SELECT * FROM file1 |
| SFTP | sftp://server:port/remotePath | URI=sftp://127.0.0.1:22/remotePath; User=user1; Password=password1; | SELECT * FROM file1 |
| Sharepoint | sp://https://server/remotePath | URI=sp://https://domain.sharepoint.com/Documents; User=user1; Password=password1; | SELECT * FROM file1 |