AutoScript

A set of handy scripts that helps to automate routine tasks.

---

Name Card Crafting

This is implemented in the form of a website

Excel

Parse and extract the information from excel files and perform a wide viarity of analysis on them.

Requirements

• Python 3.6 +
• Pandas 0.32 +
• xlrd
• OpenPyXL

Preliminary

Execute or double-click the script click_me_first.py to install the required packages

Usage

python main.py path/to/excel_file

Notes

• The default file name for the excel file is ‘target.xlsx’ with sheet name ‘Sheet1’. On windows system, one can put the target file in the same folder that contains the python script and double click the script to execute it in order to simplify the process.

• One should remove unnecessary cells such as the header and the comments before processing.