Openpyxl corrupts Excel 2010 *.xlsx file
Issue #855
resolved
File was created in Excel 2010, when i try use openpyxl (2.4.8) for generate something on it base i get "unreadable content" error message in Excel. Even without any modification:
wb = load_workbook('invoice.xlsx') response = HttpResponse(content_type='application/vnd.ms-excel') response.write(save_virtual_workbook(wb))
I get error in Excel: "Excel found unreadable content in 'invoice.xlsx'. Do you want to recover teh contents of this workbook? If you trust the source of this workbook, click Yes. (Yes) (No)"
Comments (2)
-
-
- changed status to resolved
Refactor to handle range strings that contain just rows and or columns. Resolves
#855→ <<cset 56a073508151>>
- Log in to comment
Thanks for the report and the file. The problem is related to the print area that openpyxl makes a mess off.