Created and documented a Python Script for Invoice Automation while working for Cisco AppDyanmics
*The following Excel Workbook and Word Document are not the original data for the project
**The following program runs similar to the original program
In the provided Python script, several libraries are used for different purposes. Here's a summary of the libraries and how to install them using pip:
-
pathlib: This library is used for working with file paths and directories. It is part of the Python standard library, so you don't need to install it separately.
-
pandas: Pandas is a powerful data manipulation and analysis library. It is used for reading Excel data into dataframes and for data formatting. You can install pandas using pip:
pip install pandas
-
docxtpl: The
docxtpllibrary is used for rendering Word documents with data. You can install it with pip:pip install docxtpl
-
babel: The
babellibrary is used to format currency values. It's used for converting numeric values to currency format. You can install it with pip:pip install babel
-
docx2pdf: This library is used for converting Word documents to PDF format. You can install it with pip:
pip install docx2pdf
Before running the script, make sure you have these libraries installed in your Python environment. Use the provided pip install commands to install any missing libraries.