fork download
copy 
  1. import pandas as pd
  2.  
  3. #ファイル全読み込み
  4. df = pd.read_excel('sample.xlsx', sheet_name=None)
  5.  
  6.  
  7. #Excel→CSV
  8.  
  9. for i in df:
  10. 	#シート名を表示
  11. 	print(i)
  12. 	# CSV形式で出力
  13. 	df[i].to_csv('data'+str(i)+'.csv', encoding='utf-8')
Runtime error #stdin #stdout #stderr 0.04s 9328KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Traceback (most recent call last):
  File "./prog.py", line 1, in <module>
ImportError: No module named 'pandas'
https://ideone.com/A6m6Tc
language:
Python 3 (python  3.9.5)
created:
6 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!