Goals:
- Streamlining Excel workbook and worksheet processes through user commands and back-tracking.
- Enabling automated data transfer, clustering from large datasets, '.csv' files, and Wikipedia tables—leveraging Beautiful Soup for website scraping and openpyxl/pandas for data management.
To start, run excel_automation.py and create or load an Excel workbook by typing '/wbcreate' or '/wbload' To end the program at any point, type '/end'
All commands
| Command | Function |
|---|---|
| /end | Ends the program |
| /commands | A list of all commands |
| /back | To go back in the program |
| /wb | A list of workbook commands |
| /wbcreate | Creates a new workbook |
| /wbload | Loads an existing workbook |
| /ws | A list of worksheet commands |
| /wscreate | Creates a new worksheet |
| /wschange | Changes the active worksheet |
| /wslist | A list of all the worksheets in a workbook |
| /datacsv | Transfers data from a .csv file |
| /datawiki | Transfers data from a Wikipedia table |
All commands automatically save the Excel file. However, you can also type '/save'