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.11.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | ebb17498d013d5986ebb1a685caa96d1e51dbca403ba309565037b7ed797af69 |
|
MD5 | 01352525afb323c905a5a05cf82fdc39 |
|
BLAKE2b-256 | 04feb3ec9ea38e4ccd711962855dcfd8e0161a415f1133889f9f8bead48e5338 |
Close
Hashes for tableschema_to_template-0.0.11-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a931fc25916e13b2e79757d029285adab03f610b0d3d6e29c5903356efcd9df2 |
|
MD5 | 50b404621697096b415f16b167abfd27 |
|
BLAKE2b-256 | d8affc6dacf25523c39f8208b56b67292e6bb43e7057b8aacad355cf38bbc02f |