python读取excel出错

问题描述

例如：通过python脚本利用xlrd库进行读取excel时报错

Traceback (most recent call last):
  File "D:/seleniumpractice/shkTest/excelDeal/logisticsExcelSupplement.py", line 64, in <module>
    RefineReadInformation().Refineread(2, 4, 5, 6,7,8)
  File "D:/seleniumpractice/shkTest/excelDeal/logisticsExcelSupplement.py", line 12, in Refineread
    open = xlrd.open_workbook(r'D:\seleniumpractice\shkTest\excelDeal\揽货企业数据导出20220823001.xlsx')
  File "D:\python\lib\site-packages\xlrd\__init__.py", line 170, in open_workbook
    raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported')
xlrd.biffh.XLRDError: Excel xlsx file; not supported

---

原因分析：

例如：xlrd 版本过高,不匹配.

---

解决方案：

直接代码里面用xlrd2 ,注意导包进去!

import xlrd2
import datetime


class RefineReadInformation:
    # start：开始的行数 line*:统计的列数(从0开始) num :历史累计到今年累计的中间的行数-3
    def Refineread(self, start, line0, line1, line2,line3,line4):
        #  文件的绝对路径
        open = xlrd2.open_workbook(r'D:\seleniumpractice\shkTest\excelDeal\揽货企业数据导出20220823001.xlsx')