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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distributions
Hashes for devart_excel_connector-1.1.0-cp313-cp313-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 840130ccd0dd6cead045fcd1c757e1864907e528d7bf39bbc7ba7b9dc88b9750 |
|
MD5 | 56f80b9756bd9c8451cd59e737f6fefe |
|
BLAKE2b-256 | 75ec8e4de1c7906d8c8e35cb903c16c8fb10d318dfde6be8a3081b49b734a9d7 |
Hashes for devart_excel_connector-1.1.0-cp313-cp313-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 98b8a1aadbf8d76bfc619f7110a1f9c3104aef0367d97e64d1ef76eec3729ed8 |
|
MD5 | c3620707d3b835004fb2e3186b1e2b4c |
|
BLAKE2b-256 | 2a021706e0ecda019925baa5ae5255121f4646bfb58e58be351f6c4408602140 |
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 |
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 |
Hashes for devart_excel_connector-1.1.0-cp312-cp312-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 11531ff3e503a38b931ca9944daf09897df165ce8a0073b4522de787d18e71a4 |
|
MD5 | e54ff593c148322a2b530a66d1911c6f |
|
BLAKE2b-256 | ae2dc68f40185464f8335681904e3c3cf5ef52e4af2f2dc04a49222a434ccecd |
Hashes for devart_excel_connector-1.1.0-cp312-cp312-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5e3140a60deae05fed10afccd4c6840d9d012c71bd524d9b16a5e55f4cad934c |
|
MD5 | e339b31cc559dc4d6f5aa4b9e03988fb |
|
BLAKE2b-256 | ff6d1d7fc6686d2c39c1f9cf07abf8ac420d14f550bcabcaa92a8ea0d3a2a436 |
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 |
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 |
Hashes for devart_excel_connector-1.1.0-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e99c624c61dcce00e87d2c037f0c141528488d50d884958250ed7689821c1ffb |
|
MD5 | c8e8ccaab3c5f81d97b7cb766b05db1b |
|
BLAKE2b-256 | b97963bd2bdb594f0284d8d6d9c27bbd9e98fb363cdee3401832260abfa42695 |
Hashes for devart_excel_connector-1.1.0-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d397e2fd7f5b29e2c56431ef9635a78f8a746a4afb5150466c18a7f4f2c45887 |
|
MD5 | 4617864b18feb02d46527f4dc96dce4a |
|
BLAKE2b-256 | ad63b8a51d7c670ae9a1f9c94f5bff2ba6cd51ad75eb450fe891c06518dbe43f |
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 |
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 |
Hashes for devart_excel_connector-1.1.0-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | dbcee1672c61b6303ab4457172010446bdfb53626cc593d0a2075819fde35411 |
|
MD5 | 3d4724bd5105478908d6b612f5f6e22a |
|
BLAKE2b-256 | 50ff7de35592c88e9404127d0bdd474d550624ad3ab2310e85789314ffc9bf31 |
Hashes for devart_excel_connector-1.1.0-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3c2ebef6c5bba65f38466577c203ed181f3bdb557468cf4c98136a7e1fa9f5eb |
|
MD5 | 7384556d1770fb71123c418858700c5d |
|
BLAKE2b-256 | 779d42ba17202ed18a4af318c9ae9c07c3905eacfaa4b9abaddd95ab18b1f3a5 |
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 |
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 |
Hashes for devart_excel_connector-1.1.0-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ea35a255aa799deb376fb333a725542ef2ae0dd19578966671438580cd57f92e |
|
MD5 | 51b5dfc4dfb912eba9df44d0c2d14832 |
|
BLAKE2b-256 | 7993513b6ce637a555d941828710b8359e2f8b720727f782c75f494c31beea3a |
Hashes for devart_excel_connector-1.1.0-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | eb2f519f599010f9c1544842598efe196bc1ef256bf333f3394449c1ad0f9422 |
|
MD5 | 6f957468c47da21376ce89ecf99d7490 |
|
BLAKE2b-256 | 68e87f51c4c8dd995a30ecfec6a134d93e5afd451e3525053f7bea1c4445a0f6 |
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 |
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 |
Hashes for devart_excel_connector-1.1.0-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 027e7dfbf4fa66aabbd7a13164032b90d2a092553e1d34520903bd35e46274c4 |
|
MD5 | ee090ce63d57b7fd2fc9331ada1f8eb2 |
|
BLAKE2b-256 | 2a89db52ce292c067f368d4912d344682c2aee46b4aca3433625c6081c026e80 |
Hashes for devart_excel_connector-1.1.0-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 60495ad224f578bbbdf3569437aac62b7beb9dd2e729c9674b1aec8838f3d11d |
|
MD5 | b302c816da5906391fd139edfb3cb760 |
|
BLAKE2b-256 | e9427be169b239c19381f50716a4113aad9c2511c8ce25df5b973e713b4c08fe |
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 |
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 |
Hashes for devart_excel_connector-1.1.0-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | adf02ec7da64cc29ca3ac6574c3aec432f0815fbc122bc393ecb1764300ba0fb |
|
MD5 | 0eac433bcadc4b59910e44baeb12943f |
|
BLAKE2b-256 | a18d6b7966f69e312465f38aae79093f621c1c6c3b4c2857e73ca2abf408627b |
Hashes for devart_excel_connector-1.1.0-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 21947bb476b36852446d33147a09366758850b5a5a69e4d74a4c6944fa33313f |
|
MD5 | 87b9d70cc9e82d9038afe62034dfd675 |
|
BLAKE2b-256 | e82ca302607b8c7dc4679a40eb74b357e6dd871ad280514af32d707bdeff3d79 |
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 |
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 |