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
Metadata
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 | Provenance | |
|---|---|---|---|---|
| tableschema-to-template-0.0.13.tar.gz | 13.6 kB | Without provenance | 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
|
Security for tableschema-to-template 0.0.13
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
