Connecting to Excel Services

For information on the available WHL and TAR.GZ files for supported environments, and how to install the appropriate file for your Python distribution, see Package Installation.

For information on the module to import, and how to configure the necessary connection properties in a connection string, see Establishing a Connection.

Other available connection properties can be used to configure other aspects of the connector capabilities.

Python Version Support

The CData Python Connector for Microsoft SharePoint Excel can be installed and used in various Python 3.8, 3.9, 3.10, and 3.11 distributions.

Excel Services Version Support

The connector supports retrieving Excel data from SharePoint On-Premises through the REST API and through the OData API introduced in SharePoint 2013. Excel files must have the .xlsx format used in Excel 2007 and later.

Note: Microsoft has stated that they plan to sunset the Excel Services API for SharePoint Online in February 2022. Please consider migrating to the CData connector for Excel Online for future access to your SharePoint data.

See Also

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