[go: up one dir, main page]
Skip to content

zeeshan2k2/ExcelOrderManager

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
.idea
.idea
 
 
README.md
README.md
 
 
main.py
main.py
 
 

Repository files navigation

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.

    About

    A python script used for order managment.

    Topics

    python os pandas pyexcel

    Resources

    Readme
    Activity

    Stars

    0 stars

    Watchers

    1 watching

    Forks

    0 forks
    Report repository

    Releases

    No releases published

    Packages

    No packages published

    Languages