Excel file is corrupted

Question

After read and write an excel file using python modules xlrd and xlwt, my excel file is corrupted. I faced following prompt while opening using excel 2016. But, the file is opening perfectly in google sheets...

The error excel 2016 throwing is

"Can't open file beacuse the file format or file extension is not valid"

Whats your code (and maybe file if is not too big and have nothing important in it (you may want to makes a smaller example file with placeholder value)) ? — Jorropo, Sep 24 '19 at 01:42
xlwt can only write to xls, probably the issue..try changing the extension or re-writing to proper filename — Derek Eden, Sep 24 '19 at 01:48
Seems like it is literally a typo then, since the file is written as a `.xls`, but is named `.xlsx`, which is the whole problem. Should probably close the question? — Grismar, Sep 24 '19 at 06:22

score 0 · Answer 1 · answered Sep 24 '19 at 12:49

As I mentioned in my above comment, the xlwt package (https://pypi.org/project/xlwt/) is only capable of writing to xls format.

Either change the extension of your file and try it, or change your code to save it as xls format.

I can't see your code but imagine it would look something like this:

wb.save('example.xlsx')

when it should be

wb.save('example.xls')

Excel file is corrupted

1 Answers1