Excel-Price-Processor

What it is

A python script that runs through an excel sheet and creates a column with a discounted price.

Installation

• Clone Repo: git clone https://github.com/jonathanrobin13/excel-price-processor.git
• Navigate to the folder: Type in terminal: cd excel_price_processor
• Download library: Then type: pip install -r requirements.txt

Requirements

• Python Interpreter: 3.10+
• openpyxl: if you typed "pip install -r requirements.txt", then your fine

How to use it

• Have an excel file (make sure it is downloaded on your computer)
• run the main.py
  • make sure the excel file is not open while the program is running
  • go to terminal
  • type cd excel-price-processor
  • then type python main.py (windows) or python3 main.py (mac)
• open excel file once main.py is finished running
• see your updated file

Improvements

• add labels and customization for the chart
• customization
• make an app

Credits

AI

• I did use ChatGPT only for ideas, helping me solve errors, and helping me understand python more
• There was a branch that was made because I was trying out the new Agents Window in VS code for the first time, but no code was created.

I used this python tutorial to help me: https://www.youtube.com/watch?v=_uQrJ0TkZlc