Skip to content

Latest commit

 

History

History
27 lines (18 loc) · 613 Bytes

README.md

File metadata and controls

27 lines (18 loc) · 613 Bytes

switch-pretty-printer

Generate a useful HTML page showing how switch ports are configured at an NSLS-II beamline

Requires:

  • openpyxl
  • MAC Vendor Lookup
  • datetime and json
from xlsx2html import Ports
m = Ports()
m.spreadsheet = '06BM port info.xlsx'
m.html = 'test.html'
m.read_spreadsheet()  # read data from spreadsheet
m.make_html()         # write data to an html file

Here's a link to an example

Here's a picture of an example:

example output