Metadata-Version: 2.4
Name: xlsxfill
Version: 0.1.2
Summary: Generate an xlsx by merging a template xlsx with data.
Keywords: xlsx,excel,spreadsheet,template,report
Author: HotariTobu
Author-email: HotariTobu <hotari24tools@gmail.com>
License-Expression: CC0-1.0
License-File: LICENSE
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.12
Classifier: Programming Language :: Python :: 3.13
Classifier: Topic :: Office/Business :: Financial :: Spreadsheet
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Classifier: Typing :: Typed
Requires-Dist: xlsxedit>=1.0.1
Requires-Python: >=3.12
Project-URL: Homepage, https://hotaritobu.github.io/xlsxfill/
Project-URL: Documentation, https://hotaritobu.github.io/xlsxfill/
Project-URL: Repository, https://github.com/HotariTobu/xlsxfill
Project-URL: Issues, https://github.com/HotariTobu/xlsxfill/issues
Description-Content-Type: text/markdown

# xlsxfill

[![PyPI](https://img.shields.io/pypi/v/xlsxfill)](https://pypi.org/project/xlsxfill/)
[![Python](https://img.shields.io/pypi/pyversions/xlsxfill)](https://pypi.org/project/xlsxfill/)
[![Preflight & Test](https://github.com/HotariTobu/xlsxfill/actions/workflows/preflight-and-test.yml/badge.svg)](https://github.com/HotariTobu/xlsxfill/actions/workflows/preflight-and-test.yml)
[![License](https://img.shields.io/pypi/l/xlsxfill)](LICENSE)

Generate an xlsx by merging a template xlsx with data.

The output is built through xlsxedit, so the elements of the original template
are not destroyed along the way.

## Install

```bash
pip install xlsxfill
```

## Usage

`template.xlsx`, whose first sheet looks like this:

|   | A |
|---|---|
| 1 | `${customer.name}` |

```python
from xlsxfill import fill

fill(
    "template.xlsx",
    {"customer": {"name": "Acme Inc."}},
    "output.xlsx",
)
```

`output.xlsx`:

|   | A |
|---|---|
| 1 | Acme Inc. |

The placeholder syntax is documented in
[Syntax](https://hotaritobu.github.io/xlsxfill/latest/syntax/); real workbooks
run through the library are shown in
[Samples](https://hotaritobu.github.io/xlsxfill/latest/samples/).

For language models, the documentation is indexed in
[llms.txt](https://hotaritobu.github.io/xlsxfill/latest/llms.txt), and the pages
it lists are concatenated into
[llms-full.txt](https://hotaritobu.github.io/xlsxfill/latest/llms-full.txt).

## Acknowledgments

[xlsxedit](https://github.com/jonas-kupferschmid/xlsxedit)
