CData Python Connector for Excel Services

Build 20.0.7587

Getting Started

Connecting to Excel Services

Wheel Installation explains the available WHL files for the supported environments, as well as how to install the appropriate WHL to your python distribution.

Connecting to Excel Services

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 Excel Services can be installed and used in various Python 3.6 or Python 3.7 distributions (Mac is restricted to Python 3.8), including Anacondas. Both the 32-bit and 64-bit versions of both the Windows and Linux distributions are supported, provided that the appropriate WHL file is used for installation.

Excel Services Version Support

The provider supports retrieving Excel data from SharePoint On-Premises and SharePoint Online, 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.

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.

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