# jinja2xlsx
Create xlsx-tables from html-tables
## Example
Given html table str
When render html to xlsx
Then result xlsx has table values
```python
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
```shell
poetry publish --build
```
Raw data
{
"_id": null,
"home_page": "https://github.com/potykion/jinja2xlsx",
"name": "jinja2xlsx",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7,<4.0",
"maintainer_email": "",
"keywords": "",
"author": "potykion",
"author_email": "potykion@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/30/51/ecd350bde40021eee6b3bcae2785a9bcce1636ccacfebdab019895929240/jinja2xlsx-1.2.0.tar.gz",
"platform": null,
"description": "# jinja2xlsx\n\nCreate xlsx-tables from html-tables\n\n## Example\n\nGiven html table str\n\nWhen render html to xlsx\n\nThen result xlsx has table values\n\n```python\nfrom jinja2xlsx import render_xlsx\nfrom openpyxl import Workbook\n\nhtml_str = \"\"\"<!DOCTYPE html>\n<html lang=\"en\">\n <head>\n <meta charset=\"UTF-8\">\n <title>Simple table</title>\n </head>\n <body>\n <table>\n <tbody>\n <tr>\n <td>1</td>\n <td>2</td>\n </tr>\n <tr>\n <td>3</td>\n <td>4</td>\n </tr>\n </tbody>\n </table>\n </body>\n</html>\"\"\"\n\nworkbook: Workbook = render_xlsx(html_str)\nassert tuple(workbook.active.values) == ((1, 2), (3, 4))\n```\n\n## Installation \n\n```\npip install jinja2xlsx\n```\n\nFor images support:\n\n```\npip install jinja2xlsx[pil]\n```\n\n## Development\n\nInstall dependencies:\n\n```\npoetry install\n```\n\nFor images support:\n\n```\npoetry install -E pil\n```\n\nRun tests and linting:\n\n```\npre-commit run -a\n```\n\nInstall pre-commit hooks:\n\n```\npre-commit install\n```\n\n## Extra\n\n### Publish to PyPI\n\n```shell\npoetry publish --build\n```",
"bugtrack_url": null,
"license": "MIT",
"summary": "Create xlsx-tables from html-tables",
"version": "1.2.0",
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "5f323fe194c8e3941b97757ee7a87832f584e0a1b9923776ca5faa70c0607aa9",
"md5": "31c77771466a911a56351acce04acbdc",
"sha256": "87826a863febc53c76d1090acbefe94be36bfafea6d29e0b1a49f470f9281614"
},
"downloads": -1,
"filename": "jinja2xlsx-1.2.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "31c77771466a911a56351acce04acbdc",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7,<4.0",
"size": 9969,
"upload_time": "2023-01-25T14:08:24",
"upload_time_iso_8601": "2023-01-25T14:08:24.592896Z",
"url": "https://files.pythonhosted.org/packages/5f/32/3fe194c8e3941b97757ee7a87832f584e0a1b9923776ca5faa70c0607aa9/jinja2xlsx-1.2.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "3051ecd350bde40021eee6b3bcae2785a9bcce1636ccacfebdab019895929240",
"md5": "591c6dce464c46504b9e6ee9dc473f43",
"sha256": "3604d69d02a9a57625c135293fb68bf22a3089f734d59f7bc41e4fe77854d61e"
},
"downloads": -1,
"filename": "jinja2xlsx-1.2.0.tar.gz",
"has_sig": false,
"md5_digest": "591c6dce464c46504b9e6ee9dc473f43",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7,<4.0",
"size": 8292,
"upload_time": "2023-01-25T14:08:26",
"upload_time_iso_8601": "2023-01-25T14:08:26.074372Z",
"url": "https://files.pythonhosted.org/packages/30/51/ecd350bde40021eee6b3bcae2785a9bcce1636ccacfebdab019895929240/jinja2xlsx-1.2.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-01-25 14:08:26",
"github": true,
"gitlab": false,
"bitbucket": false,
"github_user": "potykion",
"github_project": "jinja2xlsx",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "jinja2xlsx"
}