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).
Usage
Download a sample schema.yaml
, and then:
pip install tableschema-to-template
ts2xl.py schema.yaml template.xlsx
# Open with Excel:
open template.xlsx
Or to use inside Python:
from tableschema_to_template.create_xlsx import create_xlsx
schema = {'fields': [{
'name': 'a_number',
'description': 'A number!',
'type': 'number'
}]}
create_xlsx(schema, '/tmp/template.xlsx')
Additional docs:
Features
- Enum constraints transformed into pull-downs.
- Field descriptions transformed into comments in header.
- Float, integer, and boolean type validation.
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.10.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | fd789b424a5e45c539aebaf5f5f74e1261b7f16eb4395de28abb6780b0e06171 |
|
MD5 | 8daecce532da23f2cc64693d3029bd9b |
|
BLAKE2b-256 | 1f6c04d319ac00789847adcd5b55e15970d911a42eed7497cd20329f1fe462d9 |
Close
Hashes for tableschema_to_template-0.0.10-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bc87fe2e65fb3d90d09f117b71fae663b186f52d4ecb2f6a3aa68b47961bd68d |
|
MD5 | 84bc8b0e3b4f12da5551a77505bb9db1 |
|
BLAKE2b-256 | 2250b3b4deb848ed412611d98c77cf7bacbc41f1e0e6bd0e8c2ac05e95d54ec0 |