[BangPypers] xlrd

[Jayanth Koushik]

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 <
shashidhar85 at 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
> shashidhar85 at gmail.com
> +919900093835
> _______________________________________________
> BangPypers mailing list
> BangPypers at python.org
> https://mail.python.org/mailman/listinfo/bangpypers
>