Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- for item in list_documents:
- print("The item is: ", item)
- wb = openpyxl.load_workbook(path+item)
- sh = wb.get_active_sheet()
- split_item = item.split(".")[0]
- new_name = str(split_item) + ".csv"
- with open(path + new_name, 'w', newline="") as f:
- c = csv.writer(f, delimiter=";")
- counter = 0
- for r in sh.rows:
- counter += 1
- print(counter)
- c.writerow([cell.value for cell in r])
- Traceback (most recent call last):
- File "C:/Users/aprofir/Desktop/python_project/transform_data/xlsx_to_csv.py", line 31, in <module>
- c.writerow([cell.value for cell in r])
- File "C:UsersaprofirAppDataLocalProgramsPythonPython37-32libencodingscp1252.py", line 19, in encode
- return codecs.charmap_encode(input,self.errors,encoding_table)[0]
- UnicodeEncodeError: 'charmap' codec can't encode character 'u0142' in position 173: character maps to <undefined>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement