309行使用了无效的坐标或范

[tang51678]

在该行代码中，使用了一个字符串作为参数来索引sheetName对象的行。根据报错信息，该字符串是f"A1:{chr(65 + len(list1[0]) - 1)}1"。这个字符串的格式看起来是用于表示一个范围，但是它似乎不是一个有效的范围。

Traceback (most recent call last): File ".\FscanOutput_v2.2.py", line 345, in OpenPort(list1) File ".\FscanOutput_v2.2.py", line 100, in OpenPort OutPut('OpenPort', sheetList) File ".\FscanOutput_v2.2.py", line 309, in OutPut for row in sheetName[f"A1:{chr(65 + len(list1[0]) - 1)}1"]: File "C:\Users\21733\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\worksheet\worksheet.py", line 295, in getitem min_col, min_row, max_col, max_row = range_boundaries(key) File "C:\Users\21733\AppData\Local\Programs\Python\Python38\lib\site-packages\openpyxl\utils\cell.py", line 135, in range_boundaries raise ValueError(msg) ValueError: A1:1 is not a valid coordinate or range