Are you sure the files aren't encrypted? If they are, then xlrd can't handle them.
http://www.lexicon.net/sjmachin/README.html (Look at 'Unlikely to be done') Jayanth On Thu, Aug 21, 2014 at 3:26 PM, Shashidhar Paragonda < shashidha...@gmail.com> wrote: > 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 > shashidha...@gmail.com > +919900093835 > _______________________________________________ > BangPypers mailing list > BangPypers@python.org > https://mail.python.org/mailman/listinfo/bangpypers > _______________________________________________ BangPypers mailing list BangPypers@python.org https://mail.python.org/mailman/listinfo/bangpypers