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