Dear Monks,

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
All decision is left to your taste

In reply to ParseExcel but decode/decrypt it by little

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.