Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- .replace(",0,", ",1,")
- import openpyxl as xl
- wb = xl.load_workbook("sample.xlsx")
- sh = wb.active
- for cell in sh["F"]:
- cell.value = cell.value.replace(",0,", ",1,")
- wb.save("copy.xlsx")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement