Metadata-Version: 2.1
Name: devart-excel-connector
Version: 1.0.1
Summary: New level of functionality and performance in data access via Python
Home-page: https://devart.com
Author: Devart
Author-email: support@devart.com
License: LGPL with exceptions
Project-URL: Homepage, http://devart.com/python/excel
Project-URL: Download, http://devart.com/python/excel/download.html
Project-URL: History, http://devart.com/python/excel/revision_history.html
Project-URL: Documentation, http://devart.com/python/excel/overview.html
Requires-Python: >=3.7
Description-Content-Type: text/markdown
License-File: LICENSE

# 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
