Openpyxl Can Not Read Consecutive Hidden Columns

In my excel file I hide certain column(s) and when I read the column visible state with openpyxl, following situations happen: hide 'A' in excel, read out 'A' as hidden; hide 'AB

Solution 1:

Excel merges the definitions of the columns A:C together. You can check for this looking at the min and max attributes of the relevant column definition.