python excel读取出错_记一次python调试excel读取错误

日常工作之一就是帮助合作方解决自动化问题, 今天的问题是python写的Robotframework扩展库ExcelRobot在读取xlsx报错, 同样的文件昨天还是OK的. 带着疑惑开始debug

日志

将Robotframework的执行日志调到trace, 获取报告如下:1

2

3

4

5

6

7

8

9

10

11

12

13Traceback (most recent call last):

File "D:pythonlibsite-packagesrobotframework_excel-1.0.0b4-py2.7.eggExcelRobotbase.py", line 33, in open_excel

self.reader = ExcelReader(file_path, self.date_format, self.number_format, self.bool_format)

File "D:pythonlibsite-packagesrobotframework_excel-1.0.0b4-py2.7.eggExcelRobotreader.py", line 21, in __init__

self._workbook = open_workbook(self.file_path, formatting_info=self.is_xls, on_demand=True)

File "D:pythonlibsite-packagesxlrd__init__.py", line 143, in open_workbook

ragged_rows