python+openpyxl报KeyError: “There is no item named ‘[].xml‘ in the archive“

python+openpyxl报KeyError: “There is no item named ‘[].xml’ in the archive”

if __name__=='__main__':
    excelPath=r'F:\pycharm_files\selenium\数据驱动\EXCEL\测试数据2.xlsx'
    #首次打开会有报错，找不到文件，需要新建
    sheetName='搜索数据表'
    pe=PraseExcel(excelPath,sheetName)
    print(pe.getDataFromSheet())
    for i in pe.getDataFromSheet():
        print(i[0],i[1])

代码运行后报错：KeyError: “There is no item named ‘[].xml’ in the archive”

解决办法

excel的存放路径下新建一个excel，再修改代码参数（excel名，sheet名）即可。