daily pastebin goal
85%
SHARE
TWEET

Untitled

a guest Oct 11th, 2018 54 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top