Skip to content

Latest commit

 

History

History
24 lines (18 loc) · 1.36 KB

README.md

File metadata and controls

24 lines (18 loc) · 1.36 KB

Excel Order Manager

Overview

Excel Order Manager is a Python script for efficiently managing and tracking orders using an Excel spreadsheet. The script parses order information, updates the Excel file with current statuses, and provides a user-friendly interface for monitoring and managing orders.

Features

  • Order Parsing: Extracts and processes order details from input text, and adds them to an Excel file.
  • Drop-Down Menus: Includes drop-down lists for updating order statuses with custom color coding.
  • Color Coding: Uses light yellow, light orange, and light green to visually distinguish between different order statuses.
  • Status Management: Allows for easy addition of new orders and updates to existing order statuses.

    • Installation

  • Clone the repository: `git clone https://github.com/zeeshan2k2/ExcelOrderManager.git`
  • Install the required packages: `pip install -r requirements.txt`
  • Run the script: `python excel_order_manager.py`

    • Usage

  • Execute the script to initialize the Excel file.
  • Use the command-line prompts to add or update orders.
  • The Excel file will be updated with new order details and status changes.

    • Contributing

    Contributions are welcome! Please submit issues or pull requests to enhance the functionality of the script.