Registry / data / spreadsheet-handling

spreadsheet-handling

library0.1.0b5pypypiunverified

Composable pipelines for spreadsheets (JSON/YAML/CSV/XLSX) with FK helpers, validation, and IO routing. Version 0.1.0b5, requires Python >=3.10, pre-release beta with active development.

data serialization

pip install spreadsheet-handling

github ↗package ↗

INSTALL

IMPORT

SIG · SPREADSHEET-HANDLI

spreadsheet-handling

datapythonv0.1.0b5

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

SheetPipeline

✓ from spreadsheet_handling import SheetPipeline

✗ from spreadsheet_handling import SheetPipeline

Minimal example reading CSV, adding a foreign key lookup, validating a required column, and writing JSON.

from spreadsheet_handling import SheetPipeline, FkHelper import os # Build a pipeline reading from CSV, adding FK lookup, and writing to JSON pipeline = ( SheetPipeline() .read_csv('input.csv') .add_fk('dept_id', FkHelper(source='departments.csv', key_column='id', value_column='name')) .validate({'dept_id': 'required'}) .write_json('output.json') ) # Execute pipeline.run() print('Pipeline executed successfully.')

spreadsheet --version

Debug

Known issues

breakingPackage is in beta (0.1.0b5). APIs may change without notice between minor versions.

fix

Pin to exact version in requirements.txt: spreadsheet-handling==0.1.0b5

affects: <=0.1.0b5

gotchaImport path uses underscore: from spreadsheet_handling import ... not spreadsheet-handling.

fix

Use underscore in import statements.

affects: all

deprecatedThe `.validate()` method signature may change in future betas. Currently expects a dict of column names and validation rules.

fix

Check changelog before upgrading; wrap validation in a try/except ValidationError.

affects: 0.1.0b5

Upgrade

Version history

0.1.0b5latest on PyPI · released Apr 14, 2026

Audit

Dependencies

pandasrequiredUsed for reading/writing Excel and CSV files

openpyxlrequiredRequired for .xlsx file support

pyyamlrequiredRequired for YAML file support

Agent activity

10 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/StefanSchade/spreadsheet-handling ↗

packagehttps://pypi.org/project/spreadsheet-handling/ ↗