Cannot read all worksheet. One is missing.
Created originally on Bitbucket by Вячеслав Предыбайло
I'm trying to read list of worksheets from file (see in attachment) by this code:
#!python
book = load_workbook("input.xlsx", use_iterators = True)
print(book.get_sheet_names())
Output is: ['Sheet2', 'Sheet3']
Sheet1 is missing. If I open file, I'll see three sheets. But if I change (whatever how) data at Sheet1 and save file, example code will work correct and output will be ['Sheet1', 'Sheet2', 'Sheet3']
branch: 1.8 tag: 1.8.5
Attachments: input.zip