Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import xlrd
- xl_workbook = xlrd.open_workbook(r'C:\Users\gnarayan\Desktop\2019 ovarian qual check\ovary-w.strict0s EEH.xlsx')
- xl_sheet = xl_workbook.sheet_by_name('1')
- counter=0
- for index in range (0,74):
- cellqual = xl_sheet.cell(index,13)
- celldate = xl_sheet.cell(index,0)
- cellid=xl_sheet.cell(index,2)
- cellwell=xl_sheet.cell(index,1)
- if cellqual=='0':
- counter = counter + 1
- print(celldate + ',' + cellid + ',' + cellqual)
- print(counter)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement