If the encryption does not matter, then the easier way might be to remove
the encryption and proceed normally using xlrd. But I'm not sure how to do
that (don't use excel). Can anyone else in the group help with this?
Jayanth
On Thu, Aug 21, 2014 at 7:19 PM, Shashidhar Paragonda <
shashidha...@gmail.com> wrote:
> Hi Jayanth,
> >>> sorry the files were encrypted, with option available in MS-excel s/w.
> They are in read-only mode.
> >>> I saw the book.py program of xlrd lib, I dint understood about
> verbosity level and all.
> >>> is there any changes to be made to book.py ?
> >>> thanks in advance.
>
>
>
> -----------------------------------
> Regards,
>
> Shashidhar N.Paragonda
> shashidha...@gmail.com
> +919900093835
>
>
> On Thu, Aug 21, 2014 at 5:03 PM, Jayanth Koushik <jnkous...@gmail.com>
> wrote:
>
> > Actually, that might be outdated. I grepped the xlrd source for this
> > particular exception. It's raised only from once place: xlrd/book.py:896
> > (assuming you're using the latest version: 0.9.3). The particular
> function
> > 'handle_filepass' is weird...:
> >
> > def handle_filepass(self, data):
> > if self.verbosity >= 2:
> > logf = self.logfile
> > fprintf(logf, "FILEPASS:\n")
> > hex_char_dump(data, 0, len(data), base=0, fout=logf)
> > if self.biff_version >= 80:
> > kind1, = unpack('<H', data[:2])
> > if kind1 == 0: # weak XOR encryption
> > key, hash_value = unpack('<HH', data[2:])
> > fprintf(logf,
> > 'weak XOR: key=0x%04x hash=0x%04x\n',
> > key, hash_value)
> > elif kind1 == 1:
> > kind2, = unpack('<H', data[4:6])
> > if kind2 == 1: # BIFF8 standard encryption
> > caption = "BIFF8 std"
> > elif kind2 == 2:
> > caption = "BIFF8 strong"
> > else:
> > caption = "** UNKNOWN ENCRYPTION METHOD **"
> > fprintf(logf, "%s\n", caption)
> > raise XLRDError("Workbook is encrypted")
> >
> > Is that function only handling encryption if verbosity is greater than 2?
> >
> > Jayanth
> >
> >
> >
> > On Thu, Aug 21, 2014 at 4:50 PM, Jayanth Koushik <jnkous...@gmail.com>
> > wrote:
> >
> > > 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
> >
> _______________________________________________
> 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
