OpenpyXL problem with cell coordinate comparison
I have the piece of code below, but it is creating duplicates on my generate file when comparing cell.coordinate current value VS the coordinate "B1" I already know how to work around this situation, but I think is really important to get rid of this bug.
In this case when iterate a max of 26 columns this works perfectly and generates what is expecting(copying names just from column A), but if set it to iterate 27 or more columns I don't get the desired result, cause my code stops when comparing column 27 row 2 or in excel representation (AA2 < B1) when debugging the result of this comparison is TRUE when it should be FALSE because in Excel the column AA is way further to the right. Technically it has a higher level of hierarchy.
I know that in other situations this behavior is expected and it is right. A good example will be sorting names. Regardless of how many A's a name that starts with A can have, it goes before any other name that starts with letter B.
Looking forward to get this bug solved in upcoming releases.
P.S. Thank you for this Library
for row in ws.iter_rows(min_row=2, max_col=27, max_row=10):
for cell in row:
if cell.coordinate < "B1":
name = ws.cell(row=cell.row, column=1).value
arraname.append(name)