Connecting to Microsoft Excel

Package Installation explains the available WHL and TAR.GZ files for the supported environments, as well as how to install the appropriate one to your python distribution.

Establishing a Connection indicates the module to import and shows how to configure the necessary connection properties in a connection string. Other available connection properties can be used to configure other aspects of the connector capabilities.

Python Version Support

The CData Python Connector for Microsoft Excel can be installed and used in various Python 3.7, 3.8, 3.9, and 3.10 distributions (Mac is restricted to Python 3.8, 3.9 and 3.10).

Microsoft Excel Version Support

The provider supports the Office Open XML spreadsheets used by Microsoft Excel 2007 and later.

See Also

• Using the Connector: Establish connections and query Microsoft Excel through Python code.
• From SQLAlchemy: Use SQLAlchemy to establish a connection with dialect URL, and interact with Microsoft Excel data using mapped classes and Sessions.