|Problems? Is your data what you think it is?|
Opening Excel (OLE) with passwordsby rr_kreitzer (Novice)
|on Jan 07, 2004 at 23:05 UTC||Need Help??|
rr_kreitzer has asked for the wisdom of the Perl Monks concerning the following question:
I am looking to parse a Password Protected Excel file. The password is known, and I can perform a similar function with VB, How can I do it with Perl?
Other Posts on this site show how to Open an Excel Object in with Perl using Win32 and required modules.
VB way to open an Excel Object
Full VB Variables List
Workbooks.Open(TargetDoc, [UpdateLinks], [ReadOnly], Format], [Password], [WriteResPassword], IgnoreReadOnlyRecommended], [Origin], [Delimiter], [Editable], [Notify], [Converter], [AddToMru])
Similar for Word
thisDoc = Documents.Open(FileName, ConfirmConversions, ReadOnly, AddToRecentFiles, PasswordDocument, PasswordTemplate, Revert, WritePasswordDocument, WritePasswordTemplate, Format, Encoding, Visible)
where PasswordDocument is the password required to open the document
Has anyone tried this before or can I get some direction please.