I need to encode xlsx file to ISO-8859-1 and it won't do it. Why? Here is my code:
export_csv = df.to_csv (r'./test.cvs', index = None, sep=";", header=True, encoding="ISO-8859-1") export_xls = df.to_excel(r'./test.xlsx', index=None, header=True, encoding='ISO-8859-1')