Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.46 KB | None | 0 0
  1. import pandas as pd
  2. import os
  3.  
  4. filename = 'test.xls'
  5.  
  6. if os.path.exists(filename):
  7.     os.remove(filename)
  8.  
  9. df = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})
  10.  
  11. # Create a Pandas Excel writer using XlsxWriter as the engine.
  12. #writer = pd.ExcelWriter(filename, engine='xlsxwriter')
  13. writer = pd.ExcelWriter(filename,)
  14. print('open', os.path.isfile(filename))
  15.  
  16. df.to_excel(writer, sheet_name='Sheet1')
  17. writer.save()
  18. print('save', os.path.isfile(filename))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement