[已收纳]python之使用xlrd包读取表格报错(已解决)

15195775117

今天一读表格就报错：

runfile('G:/数据/WindLidar.py')
G:\数据\探空.xls
Traceback (most recent call last):
  File "G:\数据\WindLidar.py", line 22, in <module>
    workbook = xlrd.open_workbook(file)
  File "C:\ProgramData\Anaconda3\lib\site-packages\xlrd\__init__.py", line 148, in open_workbook
    bk = book.open_workbook_xls(
  File "C:\ProgramData\Anaconda3\lib\site-packages\xlrd\book.py", line 117, in open_workbook_xls
    bk.parse_globals()
  File "C:\ProgramData\Anaconda3\lib\site-packages\xlrd\book.py", line 1205, in parse_globals
    self.handle_sst(data)
  File "C:\ProgramData\Anaconda3\lib\site-packages\xlrd\book.py", line 1176, in handle_sst
    self._sharedstrings, rt_runlist = unpack_SST_table(strlist, uniquestrings)
  File "C:\ProgramData\Anaconda3\lib\site-packages\xlrd\book.py", line 1398, in unpack_SST_table
    nchars = local_unpack('<H', data[pos:pos+2])[0]
error: unpack requires a buffer of 2 bytes


网上也有同病相怜者：
在openwork报错Debug错误信息

原来，另存一份即可