Advertisement
Guest User

Untitled

a guest
May 23rd, 2019
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. import xlrd
  2. xl_workbook = xlrd.open_workbook(r'C:\Users\gnarayan\Desktop\2019 ovarian qual check\ovary-w.strict0s EEH.xlsx')
  3. xl_sheet = xl_workbook.sheet_by_name('1')
  4.  
  5. counter=0
  6.  
  7.  
  8. for index in range (0,74):
  9. cellqual = xl_sheet.cell(index,13)
  10. celldate = xl_sheet.cell(index,0)
  11. cellid=xl_sheet.cell(index,2)
  12. cellwell=xl_sheet.cell(index,1)
  13.  
  14. if cellqual=='0':
  15. counter = counter + 1
  16. print(celldate + ',' + cellid + ',' + cellqual)
  17.  
  18.  
  19.  
  20. print(counter)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement