This script is used to format our weekly SSL report

sample.xlsx is a raw ssl file exported from Digicert domain services with sensitive information stripped out

I use the popular python library openpyxl to parse the excel file and manipulate data.

pip install openpyxl # Python 2
pip3 install openpyxl # Python 3

Run the python script with the argument of the sample excel file. The output will be an excel file with the name ssl_datetimestamp.xlsx

git clone https://github.com/zaidongy/python-excel.git
cd python-excel
python3 script.py sample.xlsx

Chris Yang