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 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, with range checks on numbers.
More details in the changelog.
Related work
If you want to construct Excel files programmatically, XlsxWriter is great!
For validated data entry, 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.
From the biomedical ontologies community:
3 maintainers
Release files for tableschema-to-template 0.0.13
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| tableschema-to-template-0.0.13.tar.gz | 13.6 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| tableschema_to_template-0.0.13-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 28.4 kB
Release files / tableschema-to-template-0.0.13.tar.gz
| Download URL | tableschema-to-template-0.0.13.tar.gz |
|---|---|
| Size | 13.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
2d8d2250efb840e0ecb9012c5e879a82ef68f65dd86bdff574200fdfc978ff1c
|
|
BLAKE2b-256 checksum How to use checksums |
232d5b5c0127e959a715c5365b3b491846fba5bc1fb7f94370cc3a4fb3f51f68
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.9.12
|
Release files / tableschema_to_template-0.0.13-py3-none-any.whl
| Download URL | tableschema_to_template-0.0.13-py3-none-any.whl |
|---|---|
| Size | 14.9 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
4905500a4235740654230c3223629d26fdccb7a0457ec1d0110ea102c4f1146c
|
|
BLAKE2b-256 checksum How to use checksums |
9f7f3c129377d9b815c0bb92b8c24bbecabe5e6b13b831f38924f80d2e5b40b2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.9.12
|
