View data in Excel
View dataframes in csv or excel format.
View Data in Excel
def view(file):
if not os.path.exists('./delete'):
os.mkdir('./delete')
from datetime import datetime
now = datetime.now()
name = './delete/File_' + str(now.strftime("%d/%m/%Y %H:%M:%S")).replace(
' ', '_').replace('/', '-').replace(':', '-') + '.xlsx'
file.to_excel(name, index=None)
os.system("start EXCEL.EXE {}".format(name))
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.
Last modified January 21, 2024: updated docs (da32059)