Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for Microsoft Excel

Python Connector for Microsoft Excel is a connectivity solution for accessing Microsoft Excel, Apache OpenOffice Calc, and LibreOffice Calc spreadsheets from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows, macOS, and Linux.

Direct connection

Our connector provides the following advantages:

  • A direct access to an Excel workbook without installing Microsoft Excel or Microsoft Access Database Engine Redistributable components on the user's machine
  • Support for all major desktop platforms: Windows, macOS, and Linux
  • Support for the Microsoft Excel 2007-2021 Workbook (.xlsx), Microsoft Excel 97-2003 Workbook (.xls), and OpenDocument Spreadsheet (.ods) file formats
  • A read-only multi-user mode that enables several users to read data from a workbook simultaneously

Using the connector

To retrieve data from a database:

Import the module.

import devart.excel

Connect to a database using the connect() module method and obtain a connection object.

my_connection = devart.excel.connect(
    Database="path_to_workbook"
)

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/excel/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/excel/activate-a-license.htm

What's new

Python Connector for Microsoft Excel 1.1

  • Added support for Python 3.13

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_excel_connector-1.1.0-cp313-cp313-win_amd64.whl (1.4 MB view hashes)

Uploaded CPython 3.13 Windows x86-64

devart_excel_connector-1.1.0-cp313-cp313-win32.whl (1.2 MB view hashes)

Uploaded CPython 3.13 Windows x86

devart_excel_connector-1.1.0-cp313-cp313-manylinux_2_34_x86_64.whl (2.6 MB view hashes)

Uploaded CPython 3.13 manylinux: glibc 2.34+ x86-64

devart_excel_connector-1.1.0-cp313-cp313-macosx_10_13_universal2.whl (5.0 MB view hashes)

Uploaded CPython 3.13 macOS 10.13+ universal2 (ARM64, x86-64)

devart_excel_connector-1.1.0-cp312-cp312-win_amd64.whl (1.4 MB view hashes)

Uploaded CPython 3.12 Windows x86-64

devart_excel_connector-1.1.0-cp312-cp312-win32.whl (1.2 MB view hashes)

Uploaded CPython 3.12 Windows x86

devart_excel_connector-1.1.0-cp312-cp312-manylinux_2_34_x86_64.whl (2.6 MB view hashes)

Uploaded CPython 3.12 manylinux: glibc 2.34+ x86-64

devart_excel_connector-1.1.0-cp312-cp312-macosx_10_9_universal2.whl (5.0 MB view hashes)

Uploaded CPython 3.12 macOS 10.9+ universal2 (ARM64, x86-64)

devart_excel_connector-1.1.0-cp311-cp311-win_amd64.whl (1.4 MB view hashes)

Uploaded CPython 3.11 Windows x86-64

devart_excel_connector-1.1.0-cp311-cp311-win32.whl (1.2 MB view hashes)

Uploaded CPython 3.11 Windows x86

devart_excel_connector-1.1.0-cp311-cp311-manylinux_2_34_x86_64.whl (2.6 MB view hashes)

Uploaded CPython 3.11 manylinux: glibc 2.34+ x86-64

devart_excel_connector-1.1.0-cp311-cp311-macosx_10_9_universal2.whl (5.0 MB view hashes)

Uploaded CPython 3.11 macOS 10.9+ universal2 (ARM64, x86-64)

devart_excel_connector-1.1.0-cp310-cp310-win_amd64.whl (1.4 MB view hashes)

Uploaded CPython 3.10 Windows x86-64

devart_excel_connector-1.1.0-cp310-cp310-win32.whl (1.2 MB view hashes)

Uploaded CPython 3.10 Windows x86

devart_excel_connector-1.1.0-cp310-cp310-manylinux_2_34_x86_64.whl (2.6 MB view hashes)

Uploaded CPython 3.10 manylinux: glibc 2.34+ x86-64

devart_excel_connector-1.1.0-cp310-cp310-macosx_10_9_universal2.whl (5.0 MB view hashes)

Uploaded CPython 3.10 macOS 10.9+ universal2 (ARM64, x86-64)

devart_excel_connector-1.1.0-cp39-cp39-win_amd64.whl (1.4 MB view hashes)

Uploaded CPython 3.9 Windows x86-64

devart_excel_connector-1.1.0-cp39-cp39-win32.whl (1.2 MB view hashes)

Uploaded CPython 3.9 Windows x86

devart_excel_connector-1.1.0-cp39-cp39-manylinux_2_34_x86_64.whl (2.6 MB view hashes)

Uploaded CPython 3.9 manylinux: glibc 2.34+ x86-64

devart_excel_connector-1.1.0-cp39-cp39-macosx_10_9_universal2.whl (5.0 MB view hashes)

Uploaded CPython 3.9 macOS 10.9+ universal2 (ARM64, x86-64)

devart_excel_connector-1.1.0-cp38-cp38-win_amd64.whl (1.4 MB view hashes)

Uploaded CPython 3.8 Windows x86-64

devart_excel_connector-1.1.0-cp38-cp38-win32.whl (1.2 MB view hashes)

Uploaded CPython 3.8 Windows x86

devart_excel_connector-1.1.0-cp38-cp38-manylinux_2_34_x86_64.whl (2.6 MB view hashes)

Uploaded CPython 3.8 manylinux: glibc 2.34+ x86-64

devart_excel_connector-1.1.0-cp38-cp38-macosx_10_9_universal2.whl (5.0 MB view hashes)

Uploaded CPython 3.8 macOS 10.9+ universal2 (ARM64, x86-64)

devart_excel_connector-1.1.0-cp37-cp37m-win_amd64.whl (1.4 MB view hashes)

Uploaded CPython 3.7m Windows x86-64

devart_excel_connector-1.1.0-cp37-cp37m-win32.whl (1.2 MB view hashes)

Uploaded CPython 3.7m Windows x86

devart_excel_connector-1.1.0-cp37-cp37m-manylinux_2_34_x86_64.whl (2.6 MB view hashes)

Uploaded CPython 3.7m manylinux: glibc 2.34+ x86-64

devart_excel_connector-1.1.0-cp37-cp37m-macosx_10_9_x86_64.whl (2.6 MB view hashes)

Uploaded CPython 3.7m macOS 10.9+ x86-64

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page