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 details)

Uploaded CPython 3.13 Windows x86-64

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

Uploaded CPython 3.13 Windows x86

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

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 details)

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 details)

Uploaded CPython 3.12 Windows x86-64

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

Uploaded CPython 3.12 Windows x86

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

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 details)

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 details)

Uploaded CPython 3.11 Windows x86-64

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

Uploaded CPython 3.11 Windows x86

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

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 details)

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 details)

Uploaded CPython 3.10 Windows x86-64

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

Uploaded CPython 3.10 Windows x86

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

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 details)

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 details)

Uploaded CPython 3.9 Windows x86-64

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

Uploaded CPython 3.9 Windows x86

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

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 details)

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 details)

Uploaded CPython 3.8 Windows x86-64

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

Uploaded CPython 3.8 Windows x86

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

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 details)

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 details)

Uploaded CPython 3.7m Windows x86-64

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

Uploaded CPython 3.7m Windows x86

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

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 details)

Uploaded CPython 3.7m macOS 10.9+ x86-64

File details

Details for the file devart_excel_connector-1.1.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 840130ccd0dd6cead045fcd1c757e1864907e528d7bf39bbc7ba7b9dc88b9750
MD5 56f80b9756bd9c8451cd59e737f6fefe
BLAKE2b-256 75ec8e4de1c7906d8c8e35cb903c16c8fb10d318dfde6be8a3081b49b734a9d7

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 98b8a1aadbf8d76bfc619f7110a1f9c3104aef0367d97e64d1ef76eec3729ed8
MD5 c3620707d3b835004fb2e3186b1e2b4c
BLAKE2b-256 2a021706e0ecda019925baa5ae5255121f4646bfb58e58be351f6c4408602140

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp313-cp313-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp313-cp313-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 011cb6de9c57749de2d29cf1829f1b8119fdf045f4dc49d5f98dd045d5db77c0
MD5 b103f907e042c975c630c33ae5bd3ff5
BLAKE2b-256 880f8d8cc7863cebe1bc6c110a8187984e44620932a670474aa619df2feaac6d

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp313-cp313-macosx_10_13_universal2.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp313-cp313-macosx_10_13_universal2.whl
Algorithm Hash digest
SHA256 891439cfde981394c521db235d547197416ed304c66830bd4c1a652067792950
MD5 620df7d18eb3478ded08553511d96ac5
BLAKE2b-256 1558012eb47751823fbf5ef8d3ecc95a164e05e49632cea4555902040c260e93

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 11531ff3e503a38b931ca9944daf09897df165ce8a0073b4522de787d18e71a4
MD5 e54ff593c148322a2b530a66d1911c6f
BLAKE2b-256 ae2dc68f40185464f8335681904e3c3cf5ef52e4af2f2dc04a49222a434ccecd

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 5e3140a60deae05fed10afccd4c6840d9d012c71bd524d9b16a5e55f4cad934c
MD5 e339b31cc559dc4d6f5aa4b9e03988fb
BLAKE2b-256 ff6d1d7fc6686d2c39c1f9cf07abf8ac420d14f550bcabcaa92a8ea0d3a2a436

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp312-cp312-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp312-cp312-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 2458a5e527b52471754a0182f3772e33705111c797c5a4fd551f4572d8480a58
MD5 a486411ea17240b673147e417b698d2c
BLAKE2b-256 9e97461a013c9a31eef3913fb640b97356f7c0d2edb528420cd6c2be995f7268

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp312-cp312-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 f40ade8828e7f47f71b91b8bfa724bfd355198dd46480d589040c400eb6e9867
MD5 8c1b00f84504aaa9077c92228fc1dd9d
BLAKE2b-256 8fb089c4e3423f351c426e5dcd7bd4f0d122ba3fdae6bbab6f7c3d0a4077772a

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 e99c624c61dcce00e87d2c037f0c141528488d50d884958250ed7689821c1ffb
MD5 c8e8ccaab3c5f81d97b7cb766b05db1b
BLAKE2b-256 b97963bd2bdb594f0284d8d6d9c27bbd9e98fb363cdee3401832260abfa42695

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 d397e2fd7f5b29e2c56431ef9635a78f8a746a4afb5150466c18a7f4f2c45887
MD5 4617864b18feb02d46527f4dc96dce4a
BLAKE2b-256 ad63b8a51d7c670ae9a1f9c94f5bff2ba6cd51ad75eb450fe891c06518dbe43f

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp311-cp311-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp311-cp311-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 e55fc333f1fa9f1858f226201ea4513d0b05f925601bad731d22a2ef11a5272d
MD5 06c28609ff095f9cf9bd50bd98333741
BLAKE2b-256 b60cf64de763363502a9263eb6e87763117d4ffbf7c6999e9983a04b603daf13

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp311-cp311-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 1a7d0c25b03015c5598ae3c4005c1b138a8ceb5a79263ef00bfafe486d7f79ce
MD5 61f627af19addc26c475f0d032389e94
BLAKE2b-256 47458e26e6dcccd0e37f57f5d04e55eb9d4bb814d3e913c5497916ec942ef423

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 dbcee1672c61b6303ab4457172010446bdfb53626cc593d0a2075819fde35411
MD5 3d4724bd5105478908d6b612f5f6e22a
BLAKE2b-256 50ff7de35592c88e9404127d0bdd474d550624ad3ab2310e85789314ffc9bf31

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 3c2ebef6c5bba65f38466577c203ed181f3bdb557468cf4c98136a7e1fa9f5eb
MD5 7384556d1770fb71123c418858700c5d
BLAKE2b-256 779d42ba17202ed18a4af318c9ae9c07c3905eacfaa4b9abaddd95ab18b1f3a5

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp310-cp310-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp310-cp310-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 5988a6640a94001d152d367733d2e133b6d652a6df7828b4752dc6b58fd696dd
MD5 d7b58c49b2ceea961e6abffc14a9e688
BLAKE2b-256 006150a9f1c2a7a0572138f4c8ee9351d78cd7d9a7a1a0a8c93f69ad690c36dd

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp310-cp310-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 3d6826822d3ce804186ef6d0d19f911ed32e96a1e2b75e7dbbf2369c2f4043c9
MD5 aeb13df4b4319323c036cf006171d171
BLAKE2b-256 38302b1797f17ae7803051343bcdde3033843f24110410d0d4acc49f2a862a8f

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 ea35a255aa799deb376fb333a725542ef2ae0dd19578966671438580cd57f92e
MD5 51b5dfc4dfb912eba9df44d0c2d14832
BLAKE2b-256 7993513b6ce637a555d941828710b8359e2f8b720727f782c75f494c31beea3a

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 eb2f519f599010f9c1544842598efe196bc1ef256bf333f3394449c1ad0f9422
MD5 6f957468c47da21376ce89ecf99d7490
BLAKE2b-256 68e87f51c4c8dd995a30ecfec6a134d93e5afd451e3525053f7bea1c4445a0f6

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp39-cp39-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp39-cp39-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 081648b569adf876c5fcc46a6bf4afb67c9050563bf0f1bf5c0af415c572fd7e
MD5 ed6565d238f3bae20ea9cb2fbf3b1abb
BLAKE2b-256 7effc1800a0701da94a9d0a907f3857e1c421dcab7c728517b4d71cc3e746b6f

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp39-cp39-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 5e286b48a03c0c803828189da14f808a53d353e07b417ba72c4d18a1f7eb874f
MD5 7c6c32418917ad8555275cdf2f55f90a
BLAKE2b-256 5af351c3ad450f49032671f99ae2703a1c9511acfd956a96911c70e40cc3fdcf

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 027e7dfbf4fa66aabbd7a13164032b90d2a092553e1d34520903bd35e46274c4
MD5 ee090ce63d57b7fd2fc9331ada1f8eb2
BLAKE2b-256 2a89db52ce292c067f368d4912d344682c2aee46b4aca3433625c6081c026e80

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 60495ad224f578bbbdf3569437aac62b7beb9dd2e729c9674b1aec8838f3d11d
MD5 b302c816da5906391fd139edfb3cb760
BLAKE2b-256 e9427be169b239c19381f50716a4113aad9c2511c8ce25df5b973e713b4c08fe

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp38-cp38-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp38-cp38-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 57b22e5dbc44e22fada1db8e6deac45e881788fd32575be9cb5100f11c89e114
MD5 29dec592f3fdcfe42e9cf7e87551cb3f
BLAKE2b-256 238e4370f1f6981dcba3512adc17822bb5485918709e13f901e1a851b10b1017

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp38-cp38-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp38-cp38-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 65e0145823b9e45e49cafc69eaf4329e991570643d9856415230a75a5a374bea
MD5 981c4c8d0ab0862cfbd9fe1317b8654c
BLAKE2b-256 aba031f5f46c181c82d29a73fa680a3ac98d327b6cf20702d986abb73621768d

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 adf02ec7da64cc29ca3ac6574c3aec432f0815fbc122bc393ecb1764300ba0fb
MD5 0eac433bcadc4b59910e44baeb12943f
BLAKE2b-256 a18d6b7966f69e312465f38aae79093f621c1c6c3b4c2857e73ca2abf408627b

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 21947bb476b36852446d33147a09366758850b5a5a69e4d74a4c6944fa33313f
MD5 87b9d70cc9e82d9038afe62034dfd675
BLAKE2b-256 e82ca302607b8c7dc4679a40eb74b357e6dd871ad280514af32d707bdeff3d79

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp37-cp37m-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp37-cp37m-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 7b75c999d7fcb74afc8949ef33495dac4edbdf3cc721019c7daad52410d13e86
MD5 ab91a302518c167fc8c0c752142c88c9
BLAKE2b-256 92f5227f67f64b3e13d4dcb162fbfc4093e4ea1da86eb442a11c6992c820feb0

See more details on using hashes here.

File details

Details for the file devart_excel_connector-1.1.0-cp37-cp37m-macosx_10_9_x86_64.whl.

File metadata

File hashes

Hashes for devart_excel_connector-1.1.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm Hash digest
SHA256 dbd4a454237141a53f0c608e0190c262cfe552e6a91f699cfdbcd2de889cca02
MD5 85b9273fc0a58571c8a4ab5b3b26f974
BLAKE2b-256 3655f1d14bb2898bf8ec445cc85c0ecd313a326ca9fddc2a853e481ab924fdbc

See more details on using hashes here.

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