string - Python - Read Excel file and print output to another file -

i have excel file 2 columns. there labels in left column sorted according date. each date, list of labels appear along values on right. need read each date, find specific labels , print values accordingly. have posted excerpt original file give peek @ how looks.

row label 1    row label 2 7/21/2015      123 label 1        10.5 label 2        20.6 [.....]        15 label 5        25.9 label 6        30.5 [.....]        544 7/22/2015      456 label 1        15.8 label 2        52.8 [.....]        87 label 5        99 label 6        55 goes on.... 

now can see above, need find date first, print label 1,2 , 6 along values in right column. these labels repeat each date different values. excel has 1000's of line of kind of text , need print each date, followed labels , respective values.

the output should this.

7/21/2015 label 1       10.5 label 2       20.6 label 6       30.5 

i'm quite new python , saw posts using xlrd. i'm not sure how approach problem if can me out this, great! sort of appreciated :)

the following script should started. uses openpyxl library read excel spreadsheet in.

import openpyxl   wb = openpyxl.workbook() wb = openpyxl.load_workbook(filename='input.xlsx') ws = wb.active  row in range(2, ws.get_highest_row() + 1):     row_label_1 = ws['a%d' % row].value     row_label_2 = ws['b%d' % row].value      if row_label_1.find("/") != -1: # simple test date         print row_label_1     elif row_label_1 in ["label 1","label 2","label 6"]:         print "%-20s  %s" % (row_label_1, row_label_2) 

tested using python 2.7