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.0

Initial release of Python Connector for Microsoft Excel
Added support for Windows 32-bit and 64-bit
Added support for Windows Server 32-bit and 64-bit
Added support for macOS 64-bit and ARM (Apple M1 and M2)
Added support for Linux 64-bit

Project details

Release history Release notifications | RSS feed

1.1.0

Oct 24, 2024

This version

1.0.2

Aug 16, 2024

1.0.1 yanked

Aug 5, 2024

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.0.2-cp312-cp312-win_amd64.whl (1.4 MB view hashes)

Uploaded Aug 16, 2024 CPython 3.12 Windows x86-64

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

Uploaded Aug 16, 2024 CPython 3.12 Windows x86

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

Uploaded Aug 16, 2024 CPython 3.12 manylinux: glibc 2.34+ x86-64

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

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

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

Uploaded Aug 16, 2024 CPython 3.11 Windows x86-64

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

Uploaded Aug 16, 2024 CPython 3.11 Windows x86

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

Uploaded Aug 16, 2024 CPython 3.11 manylinux: glibc 2.34+ x86-64

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

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

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

Uploaded Aug 16, 2024 CPython 3.10 Windows x86-64

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

Uploaded Aug 16, 2024 CPython 3.10 Windows x86

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

Uploaded Aug 16, 2024 CPython 3.10 manylinux: glibc 2.34+ x86-64

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

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

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

Uploaded Aug 16, 2024 CPython 3.9 Windows x86-64

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

Uploaded Aug 16, 2024 CPython 3.9 Windows x86

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

Uploaded Aug 16, 2024 CPython 3.9 manylinux: glibc 2.34+ x86-64

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

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

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

Uploaded Aug 16, 2024 CPython 3.8 Windows x86-64

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

Uploaded Aug 16, 2024 CPython 3.8 Windows x86

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

Uploaded Aug 16, 2024 CPython 3.8 manylinux: glibc 2.34+ x86-64

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

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

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

Uploaded Aug 16, 2024 CPython 3.7m Windows x86-64

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

Uploaded Aug 16, 2024 CPython 3.7m Windows x86

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

Uploaded Aug 16, 2024 CPython 3.7m manylinux: glibc 2.34+ x86-64

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

Uploaded Aug 16, 2024 CPython 3.7m macOS 10.9+ x86-64

Hashes for devart_excel_connector-1.0.2-cp312-cp312-win_amd64.whl

Hashes for devart_excel_connector-1.0.2-cp312-cp312-win_amd64.whl
Algorithm	Hash digest
SHA256	`4c66f6fcac5736c620b1a1e687d037807786edaccdeab263c91f062a0b09510e`
MD5	`de2949565fb78342ad3d392a241a67e3`
BLAKE2b-256	`ddc2561283aefd62f5f29f1b6379bb87ba0a5a93178440d7b3b6554c74299947`

Hashes for devart_excel_connector-1.0.2-cp312-cp312-win32.whl

Hashes for devart_excel_connector-1.0.2-cp312-cp312-win32.whl
Algorithm	Hash digest
SHA256	`aa9cb8b275e89c4a9282d5e8193406be5c5b1666a84671ad61ffb79619ed2439`
MD5	`7e657b983e4deb3916d0d675f3de996b`
BLAKE2b-256	`e17ba7d927e2f675d1e56d49fd9c669a85bd30de2276adb9a076397c8d214b4f`

Hashes for devart_excel_connector-1.0.2-cp312-cp312-manylinux_2_34_x86_64.whl

Hashes for devart_excel_connector-1.0.2-cp312-cp312-manylinux_2_34_x86_64.whl
Algorithm	Hash digest
SHA256	`a5bbe4126cfc72d8e4759e4c7f11e7bd8176bf50d3b561a134447e1d5c2bf8a4`
MD5	`5cc4f8ca27e1787d53a846901afb3ae6`
BLAKE2b-256	`da12e075c4608884f1fc40b1222e66203d7fbbfff763c9040fe279b81c72cda5`

Hashes for devart_excel_connector-1.0.2-cp312-cp312-macosx_10_9_universal2.whl

Hashes for devart_excel_connector-1.0.2-cp312-cp312-macosx_10_9_universal2.whl
Algorithm	Hash digest
SHA256	`4eca34d95452b7b1202d21bc79c116b34af5fd4a82d1a3897f8e8adc4eb1a50e`
MD5	`fe00eba71be4d5c77fe197c3ea92c66e`
BLAKE2b-256	`f57022de87e88d16215c88e4cfa5daa89dc94bb262c1094ed07efe14166392f4`

Hashes for devart_excel_connector-1.0.2-cp311-cp311-win_amd64.whl

Hashes for devart_excel_connector-1.0.2-cp311-cp311-win_amd64.whl
Algorithm	Hash digest
SHA256	`9fc7c720612d1bcbc06946155f7c63f3fa745eb4b97b3ff057f0397d0b88db15`
MD5	`8759379755eeeb497e5d1b8c6522b38f`
BLAKE2b-256	`f74d3206f77db430f001c343cd8e4fb7d8be06cbfd754ecaaf10733f5d864f44`

Hashes for devart_excel_connector-1.0.2-cp311-cp311-win32.whl

Hashes for devart_excel_connector-1.0.2-cp311-cp311-win32.whl
Algorithm	Hash digest
SHA256	`886674caeced815c2900acc983cd6f1037c9f32bd6a5c77e114be1994aafd5c0`
MD5	`b3b8be92303887c9333664c3128b7934`
BLAKE2b-256	`d0542bc70abbef3a0cba4d70e8f9ac34f010fdc7d57a623962115019fbe7ee23`

Hashes for devart_excel_connector-1.0.2-cp311-cp311-manylinux_2_34_x86_64.whl

Hashes for devart_excel_connector-1.0.2-cp311-cp311-manylinux_2_34_x86_64.whl
Algorithm	Hash digest
SHA256	`4f4ddfb04b2807fdadc2949c7e0c13ec5ad007b24bc5a8de7ec7bac14be17f95`
MD5	`23f066875157a5a0674ef788a6fde90b`
BLAKE2b-256	`54884a230e37195f68e0d7ba9a2b9c9ed835bfa2ad939ea281606b8ef5da515d`

Hashes for devart_excel_connector-1.0.2-cp311-cp311-macosx_10_9_universal2.whl

Hashes for devart_excel_connector-1.0.2-cp311-cp311-macosx_10_9_universal2.whl
Algorithm	Hash digest
SHA256	`3b6f06e7e73fddd53d8a92f16efb4e60b15eb4bdbd64df6827903987eac288da`
MD5	`ede983e5a37a9eef42b2bb3adbf42cdf`
BLAKE2b-256	`3512dadc0e9a5761383dc23220563dcbb4d154b5e68d44a553582510a21002f6`

Hashes for devart_excel_connector-1.0.2-cp310-cp310-win_amd64.whl

Hashes for devart_excel_connector-1.0.2-cp310-cp310-win_amd64.whl
Algorithm	Hash digest
SHA256	`b84b3bae7cf8b3f892241f11cacb39c5f033e2bb85f496512913cedc5a467b23`
MD5	`6f3e63dc494d4ab6a47ae6dc2e41af31`
BLAKE2b-256	`0462bf5910113cc9615951b3e8d99ae32aa1f731dc8a093acc097ad7f6a60c73`

Hashes for devart_excel_connector-1.0.2-cp310-cp310-win32.whl

Hashes for devart_excel_connector-1.0.2-cp310-cp310-win32.whl
Algorithm	Hash digest
SHA256	`5677377cab2e51a9d2fec7b2b92fda663e1c95fce50889104d7fbc916a248ae7`
MD5	`e0f1257d23bc7e5698e5eacfa3105301`
BLAKE2b-256	`2ce1726f6fed641f4312a527cf116cf702690d7682ab8990ef33273d09c48a38`

Hashes for devart_excel_connector-1.0.2-cp310-cp310-manylinux_2_34_x86_64.whl

Hashes for devart_excel_connector-1.0.2-cp310-cp310-manylinux_2_34_x86_64.whl
Algorithm	Hash digest
SHA256	`cc6915eba53cedd466b5da44bde41b1ac7f060285508b18e4239cc478a2e654e`
MD5	`2c657550aec0d06cb5fb77ef3a8b852a`
BLAKE2b-256	`037c04b60aacd4fcaf958baa50be45754cd313ae1c58880fd8bd789335556967`

Hashes for devart_excel_connector-1.0.2-cp310-cp310-macosx_10_9_universal2.whl

Hashes for devart_excel_connector-1.0.2-cp310-cp310-macosx_10_9_universal2.whl
Algorithm	Hash digest
SHA256	`72ff4290f0d2ebb4af076a95865901d58e2db1895c99f77d4eb2c57d59340e6a`
MD5	`735691d30562053164233d789ea553e2`
BLAKE2b-256	`797eed15c43a2820a74facd00ed014f608646e5b109933280bec0044cac265c1`

Hashes for devart_excel_connector-1.0.2-cp39-cp39-win_amd64.whl

Hashes for devart_excel_connector-1.0.2-cp39-cp39-win_amd64.whl
Algorithm	Hash digest
SHA256	`7c25c2e2a26a29f0f18ed805411b8df6d59e7f70892f0a3a57a3f9674f003056`
MD5	`07ef4f1f933856656172b6d9460a496b`
BLAKE2b-256	`9e38824121a9c453219bbca8fe83e1615ac5b56cda9bcfe23f618e02cd7aa01d`

Hashes for devart_excel_connector-1.0.2-cp39-cp39-win32.whl

Hashes for devart_excel_connector-1.0.2-cp39-cp39-win32.whl
Algorithm	Hash digest
SHA256	`8549b9ea0884d880c82d7258f7e3169a1dd1895a9a1c3005c900bdb80ccb3ba2`
MD5	`df5042d941414504754457a644027cb4`
BLAKE2b-256	`fbaac96e3c14fbf638d4ba8c007420c903787e08a5dc86a2d17dcc535c607c95`

Hashes for devart_excel_connector-1.0.2-cp39-cp39-manylinux_2_34_x86_64.whl

Hashes for devart_excel_connector-1.0.2-cp39-cp39-manylinux_2_34_x86_64.whl
Algorithm	Hash digest
SHA256	`c9d11be7870ac3fd3b013ae4e79d1d4582eea097f23cff77136ed6c665aea8d1`
MD5	`82a881b3ffab88789d6e3ee385900d39`
BLAKE2b-256	`167ca5cca76900fec3ed27eac170a38bd85e6caf22c3ec57c09a264df57a567e`

Hashes for devart_excel_connector-1.0.2-cp39-cp39-macosx_10_9_universal2.whl

Hashes for devart_excel_connector-1.0.2-cp39-cp39-macosx_10_9_universal2.whl
Algorithm	Hash digest
SHA256	`77a5f717c993b11722ee8d4d55ab80dacf379476b847618f1a7595e25174c46d`
MD5	`e6e95ffa4dc89027a3c4024a88c8393c`
BLAKE2b-256	`1b392c0d185dd90438bf803fca6586335a4b18fb57275bdd1403a8c8faa8bcfb`

Hashes for devart_excel_connector-1.0.2-cp38-cp38-win_amd64.whl

Hashes for devart_excel_connector-1.0.2-cp38-cp38-win_amd64.whl
Algorithm	Hash digest
SHA256	`75fca56bdbd49ae2cbebeb77736b7e9fb1305744aaf8fe0676ae54124f05fc6b`
MD5	`b813098e8e752bf2e9bfe7dda884b8e3`
BLAKE2b-256	`66d4417a7d0c9ec031f43ee887f9d921c2c3307b50b7974f70b4f80ba60f35a6`

Hashes for devart_excel_connector-1.0.2-cp38-cp38-win32.whl

Hashes for devart_excel_connector-1.0.2-cp38-cp38-win32.whl
Algorithm	Hash digest
SHA256	`123523e46aa2fbe08175df6751df5bd8ab10161a4cb5c2e7f396d06f72587a56`
MD5	`48c1cab612a49ad1f581d8c62dac91b8`
BLAKE2b-256	`21e43c7f86449b863b07f931d46b958ecc9525410a0b15f7c9b9242f58b5f352`

Hashes for devart_excel_connector-1.0.2-cp38-cp38-manylinux_2_34_x86_64.whl

Hashes for devart_excel_connector-1.0.2-cp38-cp38-manylinux_2_34_x86_64.whl
Algorithm	Hash digest
SHA256	`d634a14012d498f700cd70d29c1d5c067916b7947f3bf09cd1bb39b251aa9389`
MD5	`b78014c8bbe569aa3c30a5ee9f15abcf`
BLAKE2b-256	`2dc9fdf928708e6ebcef4a7f707bcb367d2ae777f075517dba9ca5e2ece027e7`

Hashes for devart_excel_connector-1.0.2-cp38-cp38-macosx_10_9_universal2.whl

Hashes for devart_excel_connector-1.0.2-cp38-cp38-macosx_10_9_universal2.whl
Algorithm	Hash digest
SHA256	`293a1794da43e824818cfb0c798a19ed18466a3dc9e06d8a1b24286b06fc5cd5`
MD5	`acb7e116b61e03f01ca86ae1c34e1a34`
BLAKE2b-256	`4fdc1230ae4c52bc2419f15e00251739b0118e0bc01dcd04c5f475f47b8557f5`

Hashes for devart_excel_connector-1.0.2-cp37-cp37m-win_amd64.whl

Hashes for devart_excel_connector-1.0.2-cp37-cp37m-win_amd64.whl
Algorithm	Hash digest
SHA256	`73ad8ecb5757e3c394aab0901924e3a949e671f0ca7fe44a009afcfd96674b89`
MD5	`4669ac1368b4f3c2e497eff57bf7cfbd`
BLAKE2b-256	`ec76a8babcb58d38614d6e48906455f149b5b6bb5e4f6f28e2082a3a0fd469d6`

Hashes for devart_excel_connector-1.0.2-cp37-cp37m-win32.whl

Hashes for devart_excel_connector-1.0.2-cp37-cp37m-win32.whl
Algorithm	Hash digest
SHA256	`447a01835dffaa5c80eec3113045a5cd5a94aded99b01287f49cbea634cd242b`
MD5	`1afe01d1116e9d41c83ec2d51634e827`
BLAKE2b-256	`cd61d264cad28b47bf677daa86773850a30791494f9faba19244f255056c6f74`

Hashes for devart_excel_connector-1.0.2-cp37-cp37m-manylinux_2_34_x86_64.whl

Hashes for devart_excel_connector-1.0.2-cp37-cp37m-manylinux_2_34_x86_64.whl
Algorithm	Hash digest
SHA256	`678259a435fbb1eba6ed8e879560b6804b887594da43c6873ee36e31d64288c9`
MD5	`ef0fe66b006da20335707d089d4bb3c1`
BLAKE2b-256	`dca99d6b0ba06ba93662739793822dc4e0200199433c72feca59e3f30c89ed09`

Hashes for devart_excel_connector-1.0.2-cp37-cp37m-macosx_10_9_x86_64.whl

Hashes for devart_excel_connector-1.0.2-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`01074c819d96c1903f52a781fe0af2ecdeb3760aa46ba5e3e93df6356b52aba9`
MD5	`b2121b8e82afc8ee28a3318435777e25`
BLAKE2b-256	`eea68da39caf8f8a7a8df8f38da23fe49f351bad054dac9f8787563f1046a44f`