open book->delete sheet->save book results in unreadable workbook

Created originally on Bitbucket by ccurvey

If I use the following program with the attached spreadsheet, the resulting "bar.xlsx" spreadsheet that is generated is unreadable by either LibreOffice Calc or MS Excel. Given the error messages from MS Excel, I think it has something do to with a named range disappearing.

#!python

import openpyxl

book = openpyxl.load_workbook("foo.xlsx")
del book.worksheets[0]
book.active = 0
book.save("bar.xlsx")

Attachments: foo.xlsx