Skip to content

Part of the Udemy Ardit Python course. Program that grabs product and date information from .xlsx files and creates pdf invoices

Notifications You must be signed in to change notification settings

leobot1010/pdf-invoices-from-excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Project Description

This is an app that creates PDF invoices out of Excel Files.

Notes

  • openpyxl module need to be installed for pandas to be able to import excel files

Errors

AttributeError: 'int' object has no attribute 'replace'.
This occurred when first attempting to write some of the invoice data to pdf.
The product_id column as well as other columns contain information as integers but
the pdf format only accepts strings.

So I converted all cells to strings EG:

pdf.cell(w=30, h=8, txt=row["product_id"])
to
pdf.cell(w=30, h=8, txt=str(row["product_id"]))

About

Part of the Udemy Ardit Python course. Program that grabs product and date information from .xlsx files and creates pdf invoices

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages