Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. .replace(",0,", ",1,")
  2.  
  3. import openpyxl as xl
  4.  
  5. wb = xl.load_workbook("sample.xlsx")
  6. sh = wb.active
  7.  
  8. for cell in sh["F"]:
  9. cell.value = cell.value.replace(",0,", ",1,")
  10.  
  11.  
  12. wb.save("copy.xlsx")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement