It is fast, widely used and secure with the optional sandboxed template execution environment. Jinja2 is a modern and designer-friendly templating language for Python, modelled after Django’s templates. This is excerpted from Jinja2’s documentation: In addition, we use pandas to handle tables and test a couple of html-to-pdf tools.

The major tool we’ll make use of is Jinja2. To automate the process with Python, there are many options to choose from. However the task can easily become tedious when you have additional requirements.įor instance, grouping customers by attributes like regions to different folders and naming the printed files with column values would need manual and repetitive efforts.

Then you can print pdf files for every row.

With MS office, the sheet can be imported into a word template and the column names of interest can be placed accordingly in the template. Suppose you have an excel sheet with hundreds of rows and a couple of columns (a sample is shown below), and would like to generate pdf reports for individual rows according to column values. This post is a summary of the code I wrote in Python for my then-desperate wife to automatically generate hundreds of invoices.

Python pdf creator