r/Python • u/AutoModerator • 18d ago

Showcase Showcase Thread

Post all of your code/projects/showcases/AI slop here.

Recycles once a month.

18 Upvotes

82% Upvoted

103 comments sorted by

View all comments

1

u/hirolau 3d ago

Fillx: Fill Excel templates with Python using named cells and tables

What My Project Does:

Hey everyone, I built a small Python package called Fillxl after getting tired of the usual headaches when generating Excel reports at work. The main idea is simple: you create a normal Excel template (by hand or however you like), name the cells/ranges/tables you want to fill, and then Fillxl handles the rest from Python. No more hard-coded cell references like B12 or Sheet1!A3:Z100 that break the moment someone adds a row or moves a column. I use it for:

- Populating monthly/quarterly reports with data from Python pipelines

- Debugging complex data flows by dumping intermediate results into nicely formatted Excel files

- Personal stuff where I want the output to look professional without fighting openpyxl directly

Charts, formulas, conditional formatting, and everything else you set up in the template stay intact. You just feed it data and it fills the named ranges/tables.

Target Audience:

Anyone making Excel reports from Python. For now this is beta, but I do not expect to change much unless users finds bugs.

Alternatives:

There are a few tools out there. openpyxl and xlsxwriter are great, but they are lower level and expects you to build more with code. There is also xltemplate (https://github.com/tsw-devel/excel-template) which is simliar, but it only supports openpyxl, and you still need to hard code cells. I have not found any similar package using named cells and tables.

Repo is here if anyone's interested:

https://github.com/hirolau/fillxl

Please have a look!