Tag Archives: how to read xlsx with python

[python]Collecting values from xlsx

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

Posted in Python, Scripting | Tagged , , | Leave a comment