Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # -*- coding: iso-8859-1 -*-
- import glob
- import pandas as pd
- excel_files = glob.glob('D:Conversao de DadosCentral de
- UtilitariosPROJETOSXLS2CSVexcel*.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)
Add Comment
Please, Sign In to add comment