Skip to main content

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 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:

From the biomedical ontologies community:

  • CEDAR: Data entry tool based on ontologies.
  • Webulous: Google sheets plugin that adds pulldowns based on ontology terms.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for tableschema-to-template, version 0.0.12
Filename, size File type Python version Upload date Hashes
Filename, size tableschema_to_template-0.0.12-py3-none-any.whl (14.9 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size tableschema-to-template-0.0.12.tar.gz (12.1 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page