python - XLRDError: Unsupported format, or corrupt file: Expected BOF record; -


i trying open workbook through xlrd.

import xlrd workbook=xlrd.open_workbook("d:\book1.xlsx")

but throwing error below:

traceback (most recent call last): file "c:\users\testuser\documents\netbeansprojects\newpythonproject\src\newpythonproject.py", line 18, i`enter code here`n <module> workbook=xlrd.open_workbook("d:\book1.xlsx")   file "d:\xlrd-0.7.1\xlrd\__init__.py", line 429, in open_workbook biff_version = bk.getbof(xl_workbook_globals)   file "d:\xlrd-0.7.1\xlrd\__init__.py", line 1545, in getbof bof_error('expected bof record; found %r' % self.mem[savpos:savpos+8])    file "d:\xlrd-0.7.1\xlrd\__init__.py", line 1539, in bof_error raise xlrderror('unsupported format, or corrupt file: ' + msg) xlrd.biffh.xlrderror: unsupported format, or corrupt file: expected bof record; found 'pk\x03\x04\x14\x00\x06\x00'

i running in netbeans python plugin. if version of xlrd issue need link download latest version of xlrd in windows. me situation.

it looks using xlrd-0.7.1 rather old - latest version xlrd-0.9.3. testing shows 0.7.1 can not open .xlxs files can opened using 0.9.3, it's time upgrade.

you can pypi: xlrd-0.9.3. don't think msi available, should able install first extracting tarball , running python setup.py install.


Comments

Post a Comment

Popular posts from this blog

php - Submit Form Data without Reloading page -

i know question has been asked , answered bunch of times life of me can not solution work on code. believe if redo code, work properly, , in retrospect time i've spent on issue should have redone code...but beyond deadline , have working prototype up... can advise how update multiple forms on single page without reloading page? horrible @ php , complete noob js/jquery/ajax @ best. html/php in single file , believe causing me problems/is largest obstacle @ getting ajax form processing work. basically, want users to: select teams multiple dropdowns in form group 1 (league champs) , on update update db newly selected team without reloadding page. edit team scores per match , on score submit/update, update db new scores. for each requirement there multiple forms (1 each leagues, 1 each per match) have set class on each form id. everything works via php, form submission reloads page each time submitted , not ideal. i have tried ajax code here http://scotch.io/tutoria...
Read more

linux - Rails running on virtual machine in Windows -

the reason why want switch ubuntu people said gems works better on linux on windows. i don't want macbook pro rails development since love windows , cannot stand lack of apps mac. moreover, people saying ubuntu "better" mac: http://www.reddit.com/r/ubuntu/comments/1bgj1s/are_there_advantages_of_ubuntu_over_os_x_for/ does virtual box work enough doesn't have lag @ all? using i7-3517u cpu 8gb memory. need program in environment lag-free , not sluggish. or there alternatives recommend? i unsure permission settings or complicated stuffs regarding terminal. i'll using terminal develop. i'm still quite new here development in linux. please kind me >< thanks. @holyxiaoxin pretty sure should asking on superuser instead. nevertheless, suggest install ubuntu in partition instead of running virtual machine. here's guide https://help.ubuntu.com/community/windowsdualboot also, yes. developing in virtual machine accurate, @ end experiment w...
Read more