idaresiwins

OpenPyXlDiff

Apr 30th, 2019
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.41 KB | None | 0 0
  1. import openpyxl
  2.  
  3. wb = openpyxl.load_workbook("C:\Users\idaresiwins\Book1.xlsx")
  4.  
  5. sheet1 = wb.active
  6.  
  7.  
  8. for word in range(1, 967):
  9.     for comp in range(1, 621)
  10.         if sheet1.cell(row = word, column = 1).value == sheet1.cell(row = comp, column = 2).value:
  11.             pass
  12.         elif sheet1.cell(row = word, column = 1).value != sheet1.cell(row = comp, column = 2).value:
  13.             print(sheet1.cell(row = word, column = 1).value)
Advertisement
Add Comment
Please, Sign In to add comment