Registry / data / spreadsheetforms

spreadsheetforms

library0.5.0pypypi✓ verified 80d ago

Tools for creating, extracting submitted data from, and filling spreadsheet-based forms. Current version 0.5.0, requires Python >=3.7. Release cadence is irregular.

data

pip install spreadsheetforms

github ↗package ↗

INSTALL

IMPORT

SIG · SPREADSHEETFORMS

spreadsheetforms

datapythonv0.5.0

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.

Form

✓ import spreadsheetforms

✗ from spreadsheetforms import Form

Create a basic form template and write it to an Excel file.

from spreadsheetforms import Form from spreadsheetforms.sheets import SheetSpec # Define a simple form form = Form( sheets=[ SheetSpec( name='Questions', columns=['Question', 'Answer'] ) ] ) # Generate a blank spreadsheet form.to_file('my_form.xlsx')

Debug

Known issues

gotchaThe package name contains a hyphen (spreadsheetforms) but the module import uses an underscore (spreadsheetforms). PyPI does not enforce naming consistency.

fix

Use 'pip install spreadsheetforms' but 'import spreadsheetforms'.

affects: all

breakingVersion 0.4.0 changed the API for extracting submitted data: `Form.from_file()` now requires `extract_data=True` to parse data; previous versions extracted automatically.

fix

Call `Form.from_file('submission.xlsx', extract_data=True)` to get form with data.

affects: >=0.4.0

gotchaForm.to_file() overwrites existing files without warning. No prompt or backup is created.

fix

Check file existence before calling to_file or ensure you have backups.

affects: all

Upgrade

Version history

0.5.0latest on PyPI · released Oct 25, 2022

Audit

Dependencies

No dependency data recorded yet.

Agent activity

12 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/OpenDataServices/spreadsheet-forms ↗

packagehttps://pypi.org/project/spreadsheetforms/ ↗