Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. from openpyxl import load_workbook
  2. workbook = load_workbook('----------/dataset.xlsx')
  3. sheet = workbook.active
  4. for i in sheet:
  5. print(sheet.cell(row=i, column=2).value)
  6.  
  7. from openpyxl import load_workbook
  8. workbook = load_workbook('----------/dataset.xlsx')
  9. sheet = workbook.active
  10. row_count = sheet.max_row
  11. for i in range(row_count):
  12. print(sheet.cell(row=i, column=2).value)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement