Sorry, I don't use excel.
Jayanth
On Sun, Aug 24, 2014 at 4:51 PM, sayantan bhattacharya
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 f
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" wr
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...@g
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.
-
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 se
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 libra
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
wb = xlrd.open_workbook(row.SERVER_MOUNT_PATH)
File "/usr/lib/python
