a guest Oct 11th, 2018 54 Never
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('.')+'.csv'
- df = pd.read_excel(excel) # converte apenas 1 folha por arquivo
RAW Paste Data