A report parser built to streamline iso-tank depot reports into a single excel spreadsheet for easy manipulation.
Functionality created with python. Batch scripts created for ease of use.
- Parses all depot types, pdfs and xsxls.
- Adds each report as a new block within a single spreadsheet, with labeled gate in and gate out sections.
- Dates added for easy readability.
- Clone the repository into a folder.
- Create the following folder structure in the repo root.
├── reports
│ ├── ARC
│ ├── MED
│ ├── TSA
│ └── WTS- Create a virtual env with python
python -m venv .venv - Activate the virtual env
.venv\Scripts\Activate - Install the required packages
pip install -r requirements.txt - Once requirements are installed, drag and drop depot specific reports in each folder, and use run.bat, spreadsheet will be created in the root folder once finished.
- To clear spreadsheet and all reports from reports folders, run clear.bat.
- Output spreadsheet with reports added.
