As a full-stack developer, I successfully completed a project focused on automating the invoice generation process. The task involved creating a solution using Python to streamline and simplify the creation of invoices on a Windows desktop environment.
Key Steps in the Automation Process:
Creation of Word Document: A new Word file, utilizing a standard invoice template, is dynamically generated with the name of the individual the invoice is intended for.
Excel Table Integration: The standard invoice template includes an Excel table for sums and contract details. This table is populated with data extracted from a separate CSV file, and certain formatting tasks are performed, such as removing unnecessary rows and modifying field colors.
Generation of Additional Word Document: The populated Excel table is then inserted into a separate Word document, which is saved as both a .doc and a .pdf file.
PDF File Creation: The invoice itself is saved as a separate PDF file.
Technologies Used:
Python (backend development)
Word document manipulation
Excel data integration
PDF file generation
Bullet Points:
Invoice automation project
Python
Dynamic creation of Word documents
Excel table integration
Generation of PDF invoices