Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import os
- filename = 'test.xls'
- if os.path.exists(filename):
- os.remove(filename)
- df = pd.DataFrame({'Data': [10, 20, 30, 20, 15, 30, 45]})
- # Create a Pandas Excel writer using XlsxWriter as the engine.
- #writer = pd.ExcelWriter(filename, engine='xlsxwriter')
- writer = pd.ExcelWriter(filename,)
- print('open', os.path.isfile(filename))
- df.to_excel(writer, sheet_name='Sheet1')
- writer.save()
- print('save', os.path.isfile(filename))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement