I'm developing a utility to convert XLS and XLSX files to CSV, but I would like the CSV files to come out with a semicolon instead of a comma, here's the code:
# -*- coding: iso-8859-1 -*-
import glob
import pandas as pd
excel_files = glob.glob('D:\Conversao de Dados\Central de
Utilitarios\PROJETOS\XLS2CSV\excel\*.xlsx') # caminho dos arquivos excel
for excel in excel_files:
out = excel.split('.')[0]+'.csv'
df = pd.read_excel(excel) # converte apenas 1 folha por arquivo
df.to_csv(out)
Much of the code is not my own and I am not experienced in Python, if anyone can help me, I would be very grateful ...