Export dataframe to xlsx - Error "zipfile.BadZipFile: File is not a zip file"

[Baggio]

OK. Here is the solution - specify mode to be 'a', append

writer = pd.ExcelWriter(filename, engine='openpyxl', mode='a')

Alternatively, look at this one or this one where it loads the file before instantiating the pd.ExcelWriter.

I also post an answer on SO. I will appreciate if you upvote/accept the answer there

thanks buran I answered you on my post on stack overflow. If you check in the comments of the new function I added also your name as contributor.

Contributions to the current helper function: https://stackoverflow.com/users/4046632/...ab=profile


I upvoted you, but since my reputation is less than 15 it doesn't display. If you can vote my as well maybe I'll reach 15 and my upvote on you will turn visible.


thanks for the support