CData Python Connector for Excel Services

Build 20.0.7587

Connecting

Connecting with a Dialect URL

A specific URL format is used to establish a connection using SQLAlchemy. For this connector, either of the following URL formats are acceptable when creating the engine:

Format 1


import sqlalchemy as orm
engine = orm.create_engine("excelservices:///?Url=https://myorg.sharepoint.com;User=admin@myorg.onmicrosoft.com;Password=password;File=Book1.xlsx;")

Format 2


import sqlalchemy as orm
engine = orm.create_engine("excelservices://User:Password/?Url=https://myorg.sharepoint.com;File=Book1.xlsx;")

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587