Tag Archives: how to read xlsx with python

This script collects data from each column on each worksheet. The script has to be modified if used in real MS Excel. This is the result: Sheet 1 [‘192.168.1.1’, ‘10.1.1.1’] [‘10.1.1.1’, ‘192.168.1.100’] [‘tcp80’] Sheet 2 [‘1.1.1.1’] [‘2.2.2.2’] [‘Tcp80’] Advertisements