笔记-xlrd读取xlsx出错

错误:

/Users/stern/miniconda3/envs/env_rdkit/bin/python /Users/stern/PycharmProjects/Stern/DTI/EssayLargeScale/generateVocabDict.py

Enzyme_Drug_Structure.xlsx

.~Enzyme_Drug_Structure.xlsx

Traceback (most recent call last):

  File "/Users/stern/PycharmProjects/Stern/DTI/EssayLargeScale/generateVocabDict.py", line 20, in <module>

    lines = getLines(drugDir)

  File "/Users/stern/PycharmProjects/Stern/DTI/EssayLargeScale/generateVocabDict.py", line 8, in getLines

    workbook = xlrd.open_workbook(os.path.join(dir,file))

  File "/Users/stern/miniconda3/envs/env_rdkit/lib/python2.7/site-packages/xlrd/__init__.py", line 157, in open_workbook

    ragged_rows=ragged_rows,

  File "/Users/stern/miniconda3/envs/env_rdkit/lib/python2.7/site-packages/xlrd/book.py", line 92, in open_workbook_xls

    biff_version = bk.getbof(XL_WORKBOOK_GLOBALS)

  File "/Users/stern/miniconda3/envs/env_rdkit/lib/python2.7/site-packages/xlrd/book.py", line 1278, in getbof

    bof_error('Expected BOF record; found %r' % self.mem[savpos:savpos+8])

  File "/Users/stern/miniconda3/envs/env_rdkit/lib/python2.7/site-packages/xlrd/book.py", line 1272, in bof_error

    raise XLRDError('Unsupported format, or corrupt file: ' + msg)

xlrd.biffh.XLRDError: Unsupported format, or corrupt file: Expected BOF record; found '\x05stern  '

Process finished with exit code 1

源代码:

import xlrd

import os

def getLines(dir):

lines = []

for filein [_for _in os.listdir(dir)if _[0]!='.']:#这里解决问题,原因是打开了目录下的临时文件  “.~Enzyme_Drug_Structure.xlsx”

workbook = xlrd.open_workbook(os.path.join(dir,file))

sheet = workbook.sheet_by_index(0)

linesOfFile = sheet.col_values(1)

linesOfFile = [x.encode('utf-8')for xin linesOfFile]

lines.append(linesOfFile)

return lines

def writeToTxt(lines,filepath,filename):

with open(os.path.join(filepath,filename),'w')as f:

for linein lines:

f.write(line)

drugDir ='/Users/stern/Desktop/Dataset/LargeScale/DictFile/Drug_smi'

lines = getLines(drugDir)

writeToTxt(lines,drugDir,'drugLines.txt')

©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容

  • 错误: -----------------------------------------------------...
    _sunnyRain阅读 3,260评论 2 2
  • # Awesome Python [![Awesome](https://cdn.rawgit.com/sindr...
    emily_007阅读 2,227评论 0 3
  • 单例模式 饿汉式:无法延迟加载 懒汉模式:线程安全 synchronized DCL:会被指令重排序 volila...
    格锅阅读 208评论 0 0
  • 第一章 清晨,绍安寺主殿中传出一声怒喝:孽畜!你竟瞒着住持,暗地里修习鬼道?!九重台阶之上,一名身着袈裟的僧人向正...
    干卿底事阅读 181评论 0 1