|Problems? Is your data what you think it is?|
ParseExcel but decode/decrypt itby little (Curate)
|on Sep 05, 2007 at 19:33 UTC||Need Help??|
little has asked for the
wisdom of the Perl Monks concerning the following question:
I am a bit in need of help.
Using SpreadSheet::ParseExcel ist nice but has for me one problem. Eventhough I think this interferes with the "underlying" OLE::Simple I cannot get to read an excel file if someone had set a password for any of the Worksheets conatined within the Workbook.
As I read from various but rare docs, it is that Excel will encrypt the Streams for the Worksheets using RC4 if one single password had been set.
Now I do seek help as I hope there'd be someone around who faced that problem earlier and already solved it or who might give me a shot at the right direction.
I already fumbled with ParseExcel.pm in thus adding functions to read FilePass etc. But even then whgen I know that a file had been encrypted I just got stuck.
I have no idea of what the excel ole stream actually looks like, and its sadly no option to go for an unencrypted file as the protection shall protect actually some scripts within the Workbook but every Excel app could open and read and also show the data on most of the sheets.
It would suffice my needs at all if I'd be able to "just" extract the contenst of the Worksheets and skipping the rest as I need to parse that data anyway later into another app. And as fortunate as I seem to have happen these days its also no option to ask for an csv-file. "No go" I've been told.
So, please if anybody would be up to help in solving this it would be greatly appreciated and I have to point to the fact that my boss actually could be willing to honor professional work as well.
I am looking forward to any comment.
Thanks for your teaming reading this.
Have a nice day