{"library":"spreadsheet-handling","title":"spreadsheet-handling","type":"library","description":"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.","language":"python","status":"active","last_verified":"Sat May 09","install":{"commands":["pip install spreadsheet-handling"],"cli":{"name":"spreadsheet","version":"sh: 1: spreadsheet: not found"}},"imports":["from spreadsheet_handling import SheetPipeline","from spreadsheet_handling import FkHelper","from spreadsheet_handling import ValidationError"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":"https://github.com/StefanSchade/spreadsheet-handling","docs":null,"changelog":null,"pypi":"https://pypi.org/project/spreadsheet-handling/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"from spreadsheet_handling import SheetPipeline, FkHelper\nimport os\n\n# Build a pipeline reading from CSV, adding FK lookup, and writing to JSON\npipeline = (\n    SheetPipeline()\n    .read_csv('input.csv')\n    .add_fk('dept_id', FkHelper(source='departments.csv', key_column='id', value_column='name'))\n    .validate({'dept_id': 'required'})\n    .write_json('output.json')\n)\n\n# Execute\npipeline.run()\nprint('Pipeline executed successfully.')","lang":"python","description":"Minimal example reading CSV, adding a foreign key lookup, validating a required column, and writing JSON.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}