Guest User

Untitled

a guest
Oct 11th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. # -*- coding: iso-8859-1 -*-
  2. import glob
  3. import pandas as pd
  4.  
  5. excel_files = glob.glob('D:Conversao de DadosCentral de
  6. UtilitariosPROJETOSXLS2CSVexcel*.xlsx') # caminho dos arquivos excel
  7.  
  8. for excel in excel_files:
  9. out = excel.split('.')[0]+'.csv'
  10. df = pd.read_excel(excel) # converte apenas 1 folha por arquivo
  11. df.to_csv(out)
Add Comment
Please, Sign In to add comment