# pydeepxlsx
`pydeepxlsx` is a package used to build a XLSX file using [openpyxl](https://openpyxl.readthedocs.io/en/stable/) and a XLSX file as a template.
```mermaid
flowchart LR
id1[(Database)]
id2(XLSX template file)
id3[[pydeepxl]]
id4(XLSX generated file)
id1-->id3
id2-->id3
id3-->id4
```
## Install it from PyPI
```bash
pip install project_name
```
## Usage
See [Documentation](https://github.com/wildsys/pydeepxlsx/docs/pydeepxlsx/index.html)
### Simple use case
```py
from pydeepxlsx import PyDeepXLSX
xlsx = PyDeepXLSX('./demo.xlsx')
xlsx.copy_as_it('Demo', 0)
xlsx.append_lines(
'Demo',
[
{
'item': 'Titi',
'unit_price': 3500,
'quantity': 0.05,
'vat': 0.1
},
{
'item': 'Toto',
'unit_price': 1500,
'quantity': 0.001,
'vat': 0.2
}
]
)
xlsx.wb.save('./test.xlsx')
```
## Development
Read the [CONTRIBUTING.md](CONTRIBUTING.md) file.
Raw data
{
"_id": null,
"home_page": "https://www.python.org/sigs/distutils-sig/",
"name": "pydeepxlsx",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.9",
"maintainer_email": "",
"keywords": "xlsx,copy",
"author": "WildSys",
"author_email": "WildSys <hello@wildsys.io>",
"download_url": "https://files.pythonhosted.org/packages/30/28/950cf4533b44e6b71b38786b59f67c65570f349321727201445eca07f12b/pydeepxlsx-1.0.4.tar.gz",
"platform": null,
"description": "# pydeepxlsx\n\n`pydeepxlsx` is a package used to build a XLSX file using [openpyxl](https://openpyxl.readthedocs.io/en/stable/) and a XLSX file as a template.\n\n```mermaid\nflowchart LR\n id1[(Database)]\n id2(XLSX template file)\n id3[[pydeepxl]]\n id4(XLSX generated file)\n id1-->id3\n id2-->id3\n id3-->id4\n```\n\n## Install it from PyPI\n\n```bash\npip install project_name\n```\n\n## Usage\n\nSee [Documentation](https://github.com/wildsys/pydeepxlsx/docs/pydeepxlsx/index.html)\n\n### Simple use case\n\n```py\nfrom pydeepxlsx import PyDeepXLSX\n\nxlsx = PyDeepXLSX('./demo.xlsx')\nxlsx.copy_as_it('Demo', 0)\nxlsx.append_lines(\n 'Demo',\n [\n {\n 'item': 'Titi',\n 'unit_price': 3500,\n 'quantity': 0.05,\n 'vat': 0.1\n },\n {\n 'item': 'Toto',\n 'unit_price': 1500,\n 'quantity': 0.001,\n 'vat': 0.2\n }\n ]\n)\nxlsx.wb.save('./test.xlsx')\n```\n\n## Development\n\nRead the [CONTRIBUTING.md](CONTRIBUTING.md) file.\n",
"bugtrack_url": null,
"license": "",
"summary": "XLSX file as a template",
"version": "1.0.4",
"project_urls": {
"Bug Tracker": "https://github.com/wildsys/pydeepxlsx/issues",
"Homepage": "https://github.com/wildsys/pydeepxlsx"
},
"split_keywords": [
"xlsx",
"copy"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "7d857e151fb636ee95401b65272201769392fc5ed02b7bd006321324116a824a",
"md5": "2fe77b0327f8ec50944482ff7efcad8e",
"sha256": "749526dbf79d550e8a4f184b7cc11b8433af3c4ddf5e6b5d691ebe44ce001365"
},
"downloads": -1,
"filename": "pydeepxlsx-1.0.4-py3-none-any.whl",
"has_sig": false,
"md5_digest": "2fe77b0327f8ec50944482ff7efcad8e",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9",
"size": 4700,
"upload_time": "2023-09-20T06:19:45",
"upload_time_iso_8601": "2023-09-20T06:19:45.107895Z",
"url": "https://files.pythonhosted.org/packages/7d/85/7e151fb636ee95401b65272201769392fc5ed02b7bd006321324116a824a/pydeepxlsx-1.0.4-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "3028950cf4533b44e6b71b38786b59f67c65570f349321727201445eca07f12b",
"md5": "2a8d0692ca9fd18a682ea95629bad9e2",
"sha256": "29c60b0e6dfcb46a774d7de0bc18905e45b21a2b847ab6d3c68f72b4002769bf"
},
"downloads": -1,
"filename": "pydeepxlsx-1.0.4.tar.gz",
"has_sig": false,
"md5_digest": "2a8d0692ca9fd18a682ea95629bad9e2",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9",
"size": 4765,
"upload_time": "2023-09-20T06:19:46",
"upload_time_iso_8601": "2023-09-20T06:19:46.759941Z",
"url": "https://files.pythonhosted.org/packages/30/28/950cf4533b44e6b71b38786b59f67c65570f349321727201445eca07f12b/pydeepxlsx-1.0.4.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-09-20 06:19:46",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "wildsys",
"github_project": "pydeepxlsx",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "pydeepxlsx"
}