Skip to content

v0.1.1

Choose a tag to compare

View all tags
@yeongseon yeongseon released this 12 Apr 04:58
· 154 commits to main since this release
v0.1.1
97e0f2a

excel-dbapi v0.1.1

PEP 249 compliant DB-API 2.0 driver for Excel files.

Features

  • Full DB-API 2.0 interface (connect, cursor, execute, fetch)
  • SQL parser: SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, DROP TABLE
  • WHERE clause with =, !=, <, >, <=, >=, AND, OR, IS NULL, IS NOT NULL
  • ORDER BY, LIMIT support
  • Parameterized queries (qmark style)
  • Reflection helpers: list_tables, has_table, get_columns
  • DDL metadata tracking via excel_meta sheet
  • openpyxl (default) and pandas engines

Requirements

  • Python >= 3.10
  • openpyxl >= 3.1.0

Install

pip install excel-dbapi
Assets 2
Loading