Error opening xlsx file
Created originally on Bitbucket by Archon
One file gives error which i couldn't figure out. File seems all sane. Yet the traceback seems to point to loading the sheets. This file has just 1 sheet with title in Russian.
Here goes error as follows: {{{ #!python
MyBook:Development polzovatel$ python readwritexls.py Found XLSX file: /tmp/xlmail/123.xlsx Traceback (most recent call last): File "readwritexls.py", line 38, in wb = load_workbook(filename = xfilename) File "/Users/polzovatel/Desktop/Development/openpyxl/reader/excel.py", line 50, in load_workbook sheet_names = read_sheets_titles(xml_source = archive.get_from_name(arc_name = ARC_APP)) File "/Users/polzovatel/Desktop/Development/openpyxl/reader/workbook.py", line 65, in read_sheets_titles size = get_number_of_parts(xml_source)['Worksheets'] KeyError: 'Worksheets'
}}}
running diff on one working and unworking one xlsx files showed only absence of sheets.xml's, so the structure is fine. {{{ #!python
MyBook:xlmail polzovatel$ diff -rq 'e11A_Milan_Inventory.xlsx Folder' 'Отгрузка по ВКМ за 06.09.2010-07.09.2010г..xlsx Folder' Only in e11A_Milan_Inventory.xlsx Folder/xl/worksheets: sheet2.xml Only in e11A_Milan_Inventory.xlsx Folder/xl/worksheets: sheet3.xml MyBook:xlmail polzovatel$ }}}
Erroneous file included.
Attachments: 123.xlsx