Kim:Tablemaker

import openpyxl import numpy as np

wb = openpyxl.load_workbook('Former_lab_Members.xlsx') sheet = wb.get_sheet_by_name('Sheet1') print(sheet.max_row) # should match rows in spreadsheet formerTable = list(sheet['A1:C{0}'.format(sheet.max_row)])

1. print table entries to the console

def printItAll(valign, name, position, positionAfterLab):

   print(valign)
   print(name)
   print(position)
   print(positionAfterLab)
   print() 

valign = "" name = "" position = "" positionAfterLab = ""

for row in formerTable:

   rowarray = np.array(row)
   if rowarray[0].value is not None:
       printItAll(valign, name, position, positionAfterLab)
       valign = ("|-valign=\"top\"") 
       name = ("|{0}".format(rowarray[0].value))
       position = ("|{0}".format(rowarray[1].value))
       positionAfterLab = ("|{0}".format(rowarray[2].value))
   elif rowarray[2].value is not None:  
       positionAfterLab = positionAfterLab + " " + rowarray[2].value

printItAll(valign, name, position, positionAfterLab)