Python Connector for Microsoft Excel（英語版）

PythonアプリケーションからMicrosoft Excelスプレッドシートにアクセスして、格納されているデータに対して作成、読み取り、更新、削除操作を実行

Devart 社の製品
2005 年より日本国内にてComponentSourceで販売中。

価格:¥ 31,130 (税込)〜 バージョン: 1.1.0 更新日: Oct 23, 2024

Python Connector for Microsoft Excel（英語版） のスクリーンショット

Python Connector for Microsoft Excel について

PythonアプリケーションからMicrosoft Excelスプレッドシートにアクセスして、格納されているデータに対して作成、読み取り、更新、削除操作を実行

Python Connector for Microsoft Excel is a reliable connectivity solution for accessing Microsoft Excel, Apache OpenOffice Calc, and LibreOffice Calc spreadsheets from Python applications to perform create, read, update, and delete operations on stored data. The solution fully implements the Python DB API 2.0 specification and is distributed as a wheel package for Windows, macOS, and Linux.

Python Connector for Microsoft Access Features

  • Direct Connection - The solution enables you to establish a direct connection to an Excel workbook without installing Microsoft Excel or Microsoft Access Database Engine Redistributable on your machine. It supports the Microsoft Excel Workbook (.xlsx), Microsoft Excel 97-2003 Workbook (.xls), and OpenDocument Spreadsheet (*.ods) file formats. The read-only multi-user mode enables several users to read data from a workbook simultaneously.
  • High Performance - The connector supports a direct connection to an Excel workbook without Microsoft Access Database Engine Redistributable components. It also lets you submit multiple update statements to the workbook for processing as a batch to improve execution time.
  • Fast Deployment - If your Python application must be deployed on multiple user workstations, you don't have to supply Microsoft Access Database Engine Redistributable components for every user since the connector supports a direct connection.
  • Platform Support - The Python connector is available for Windows 32-bit and 64-bit, macOS 64-bit, and Linux 64-bit.
  • Data Types Support - The connector supports all Microsoft Excel and Python data types. It offers additional options to control data type mapping between the Microsoft Excel data types and Python data types.