I opened and read values from an existing excel file using openpyxl (v2.0.4) with attribute use_iterators = True. Then I updated some cells with new data (using normal mode, not optimized). A snippet of the code which I used is given below.
workbook = load_workbook(excelFileName) worksheet = workbook.get_sheet_by_name(sheetName) worksheet['B2'] = "Some value" workbook.save(excelFileName)
Now when I open the excel file, it is full blank and the cell start location is 'AML1'. I am not able to see any cells before it. If I type the cell name in the selection field it shows the correct value. But I am not able to see it in the spreadsheet.
Ps: This writing feature works perfectly fine in v1.8.5. I notice the problem in v2.0.4 only.
Attachment: A sample excel file generated through openpyxl with the above said issue.