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')
Instructions for project developers here.
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.9.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9abf244d7b2e337d25422ce9fee487ea57be3a0f2e9cbe465d1322927cff45ea |
|
MD5 | 139ff3c258c355a6a7d51799ab44d7ba |
|
BLAKE2b-256 | 100dc99b305a10d6ee47117385107944a53ced04c89151a6c07c247389909b03 |
Close
Hashes for tableschema_to_template-0.0.9-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b48a844e7d538b8bab89d1b99443fbb73289a62c674a3762e2055e922ba883b2 |
|
MD5 | a8d4b8c4b16411f4566b00ffb188f6b2 |
|
BLAKE2b-256 | 834713e8db8ed7bd360e19e43e64258b697581e186b03202ddaf6eb63d9646fa |