Skip to main content

Create xlsx-tables from html-tables

Project description

jinja2xlsx

Create xlsx-tables from html-tables

Example

Given html table str

When render html to xlsx

Then result xlsx has table values

from jinja2xlsx import render_xlsx
from openpyxl import Workbook

html_str = """<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Simple table</title>
    </head>
    <body>
        <table>
            <tbody>
                <tr>
                    <td>1</td>
                    <td>2</td>
                </tr>
                <tr>
                    <td>3</td>
                    <td>4</td>
                </tr>
            </tbody>
        </table>
    </body>
</html>"""

workbook: Workbook = render_xlsx(html_str)
assert tuple(workbook.active.values) == ((1, 2), (3, 4))

Installation

pip install jinja2xlsx

For images support:

pip install jinja2xlsx[pil]

Development

Install dependencies:

poetry install

For images support:

poetry install -E pil

Run tests and linting:

pre-commit run -a

Install pre-commit hooks:

pre-commit install

Extra

Publish to PyPI

poetry publish --build

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 jinja2xlsx, version 0.4.0
Filename, size File type Python version Upload date Hashes
Filename, size jinja2xlsx-0.4.0-py3-none-any.whl (8.7 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size jinja2xlsx-0.4.0.tar.gz (7.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