[BangPypers] xlrd

Shashidhar Paragonda shashidhar85 at gmail.com
Thu Aug 21 11:56:12 CEST 2014


Hello all,
>>> I am using xlrd library to read .xls files,
>>> wb = xlrd.open_workbook("workbook_name.xls")
>>> when I execute I get error :

Traceback (most recent call last):
  File "rater_document_parser.py", line 72, in <module>
    wb = xlrd.open_workbook(row.SERVER_MOUNT_PATH)
  File "/usr/lib/python2.6/site-packages/xlrd/__init__.py", line 435, in
open_workbook
    ragged_rows=ragged_rows,
  File "/usr/lib/python2.6/site-packages/xlrd/book.py", line 116, in
open_workbook_xls
    bk.parse_globals()
  File "/usr/lib/python2.6/site-packages/xlrd/book.py", line 1178, in
parse_globals
    self.handle_filepass(data)
  File "/usr/lib/python2.6/site-packages/xlrd/book.py", line 896, in
handle_filepass
    raise XLRDError("Workbook is encrypted")
xlrd.biffh.XLRDError: Workbook is encrypted

>>> when I manually open, it open
>>> any suggession on resolving this error.
>>>Thank you.



-----------------------------------
Regards,

Shashidhar N.Paragonda
shashidhar85 at gmail.com
+919900093835


More information about the BangPypers mailing list