Skip to main content

Openpyxl-templates is an extention to openpyxl which simplifies reading and writing excelfiles by formalizing their structure into templates.

Project description

https://badge.fury.io/py/openpyxl-templates.svg https://readthedocs.org/projects/openpyxl-templates/badge/?version=latest

Welcome to openpyxl-templates!

Openpyxl-templates is an extention to openpyxl which simplifies reading and writing excelfiles by formalizing their structure into templates. The package has two main components:

  1. The TemplatedWorkbook which describe the excel file
  2. The TemplatedSheets which describe the individual sheets within the file

The package is build for developers to be able to implement their own templates but also provides one useful templated sheet. The TableSheet which makes it significantly easier to read and write data from excel data tabels such as this one:

docs/examples/fruit_lovers.png

The TableSheet provides an easy way of defining columns and handles both styling and conversion to and from excel. See quickstart for a demo.

Github
https://github.com/SverkerSbrg/openpyxl-templates
Documentation
http://openpyxl-templates.readthedocs.io/en/latest/
pypi
https://pypi.python.org/pypi/openpyxl-templates
openpyxl
https://openpyxl.readthedocs.io/en/default/

If you have any questions or ideas regarding the package feel free to reach out to me via GitHub.

Warning

This package is still in beta. The api may still be subject to change and the documentation is patchy.

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 openpyxl-templates, version 0.2.5
Filename, size & hash File type Python version Upload date
openpyxl_templates-0.2.5-py2.py3-none-any.whl (23.7 kB) View hashes Wheel py2.py3

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page