Given a Frictionless Table Schema, generates an Excel template with input validation
Project description
tableschema-to-template
Given a Frictionless Table Schema (like this), generate an Excel template with input validation (like this).
This is a proof of concept.
Usage
pip install tableschema-to-template
wget https://raw.githubusercontent.com/hubmapconsortium/tableschema-to-template/main/tests/fixtures/schema.yaml
ts2xl.py \
--input_schema schema.yaml \
--output_dir /tmp
# Open with Excel:
open /tmp/template.xlsx
Development
From a checkout of the repo, run a demo:
pip install -r requirements.txt
tableschema_to_template/ts2xl.py \
--input_schema tests/fixtures/schema.yaml \
--output_dir /tmp
# Open with Excel:
open /tmp/template.xlsx
Run the tests:
pip install -r requirements-dev.txt
./test.sh
To build and publish,
- If you haven't already, generate a token on Pypi and create a
.pypirc
in your checkout. - Increment the version number in setup.py.
- Finally:
./publish.sh
Next steps
- How, and whether, to validate regex patterns. Possibilities:
- Don't even try!
- Add VBA to provide regex support in Excel.
- Target Google Sheets, which provides a regex function out of the box.
- Or target OpenOffice, where regexes can be turned on in the settings.
Related work
From the Frictionless community:
table-schema-resource-template
: Generates templates, but doesn't go beyond row headers.data-curator
: Desktop application for data entry based on Table Schema.csv-gg
: Web app which serves data entry form, and uses Validata API for validation.
For the biomedical ontologies community:
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for tableschema-to-template-0.0.3.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | f28cfe919fcf81cdfd59ca45470549ec53dfad1b294f87e0ff2e0eeaa7ced9a9 |
|
MD5 | 3bab01e5289ca855250639e1f00f4fe7 |
|
BLAKE2b-256 | ceb23690b6606cae1a1bfa14c797e074e19d37e167bfac55ce2d9010e9e66375 |
Close
Hashes for tableschema_to_template-0.0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4743c42fd234b8b81416d428b5468fb3bee8fd4a2940e6237af30d7dc8a554bc |
|
MD5 | 4e1f85686c4ad32e1688c125c9a291b7 |
|
BLAKE2b-256 | 5dde1d41680fba13f4c2839a8e1b38cb733a114e5746137c150dbc44251dc13d |