spreadsheet-handling 0.1.0b5

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

AI Usage & Position Statement

• AI tools are used at all levels of this project: requirement analysis, solution design, coding.
• Human oversight, testing, and review remain essential. AI augments reasoning and speed but does not replace engineering judgment.
• Quality and maintainability are goals treated with priority; AI contributes to these.

Industry trends support this approach: according to the JetBrains Developer Ecosystem 2025 survey published by Golem.de, AI adoption is already pervasive and considered a core competency.

License

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