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

.. image:: https://badge.fury.io/py/openpyxl-templates.svg
:target: https://badge.fury.io/py/openpyxl-templates

.. image:: https://readthedocs.org/projects/openpyxl-templates/badge/?version=latest
:target: http://openpyxl-templates.readthedocs.io/en/latest/?badge=latest

==============================
Welcome to openpyxl-templates!
==============================

Openpyxl-templates is an extention to `openpyxl <http://openpyxl.readthedocs.io/>`_ 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:

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

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

openpyxl_templates-0.1.15-py2.py3-none-any.whl (22.0 kB view details)

Uploaded Python 2Python 3

File details

Details for the file openpyxl_templates-0.1.15-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for openpyxl_templates-0.1.15-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 55d406e702fefa385f2d2717177f51cf80ba1a3f3efe03667b4fa4d1c7343170
MD5 3e48378aa73b4874a7bd5090928142fb
BLAKE2b-256 9639077b76dfef99bcc1ffb219082a5c70ef3cd44f83e70c91ff3220b3796f2c

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page