spreadsheet-handling 0.1.0b2

Composable pipelines for spreadsheets (JSON/YAML/CSV/XLSX) with FK helpers, validation, and IO routing.

Spreadsheet Handling

Spreadsheet Handling is a Python toolkit for packing/unpacking and orchestrating tabular data.
It converts between JSON, CSV, and Excel (XLSX/ODS) while preserving relationships such as foreign keys, indexes, and hierarchies.
The goal is to make complex spreadsheet models easier to validate, transform, and round-trip into structured formats.

---

Features

• Convert JSON ↔ CSV/Excel with round-tripping support
• Detect and enforce foreign key relationships
• Validate spreadsheet structures (naming rules, uniqueness, etc.)
• Orchestrate multi-sheet pipelines via YAML configs
• Extensible: plug in new backends and transformation steps

---

Installation

# clone repo
git clone https://github.com/StefanSchade/spreadsheet-handling.git
cd spreadsheet-handling

# set up environment
make setup

Usage

Pack JSON into Excel:

sheets-pack examples/roundtrip_start.json -o demo.xlsx --levels 3

Unpack Excel back into JSON:

sheets-unpack demo.xlsx -o demo_out --levels 3

Run full test suite:

make test

License

This project is licensed under the terms of the MIT License. See LICENCE for details.