How to Save DataFrame to Excel file using filedialouge in Python?

user_16984704 0
Viewed 731

How can we write DataFrame object of Pandas using filedialouge in python tkinter.

file = filedialog.asksaveasfile(mode='w', defaultextension=".xlsx")
data.to_excel(file)

Whenever I try to write it it gives me error.

stat: path should be string, bytes, os.PathLike or integer, not _io.TextIOWrapper

I have been searching this error for hours, but the solutions are not working.

tkinter python
2 Answers

use

file = filedialog.asksaveasfilename(defaultextension=".xlsx")

tkinter.filedialog.asksaveasfilename will return filename as string, not file object like tkinter.filedialog.asksaveasfile

user_40466320

You need to use str:

data.to_excel(str(file) + '.xlsx')
user_87083640
Related