tigrbl_engine_xlsx 0.1.1.dev5

XLSX engine plugin for tigrbl where each workbook is a database and each sheet is a table.

tigrbl_engine_xlsx

A tigrbl engine plugin where each workbook is a database-like object and each sheet is a table.

Features

• Registers kind="xlsx" through the tigrbl.engine entry-point group.
• Uses load_workbook, wb[...], and wb.save(...) directly for workbook operations.
• Treats each sheet as a table with transactional table semantics.

Installation

uv

uv add tigrbl_engine_xlsx

pip

pip install tigrbl_engine_xlsx

Usage

from tigrbl.engine import EngineSpec

spec = EngineSpec(kind="xlsx", mapping={"path": "./workbook.xlsx", "pk": "id"})
provider = spec.provider()
engine, session_factory = provider.build()

session = session_factory()
wb = session.workbook()
print(wb["Sheet1"])
print(session.table("Sheet1"))