Sorry, I don't use excel. Jayanth
On Sun, Aug 24, 2014 at 4:51 PM, sayantan bhattacharya <skb655...@gmail.com> wrote: > Hi Jayanth, > > Can you provide me the excel file or a similar file with corresponding > arbit data? I have worked with xlrd and xlwt before and have not faced any > issue like this - though the files I have been using are not password > protected. > > -- > Sayantan > On Aug 21, 2014 8:32 PM, "Jayanth Koushik" <jnkous...@gmail.com> wrote: > > > 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 > > > _______________________________________________ > 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