CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Win32 Programming Help:
How to edit cells of password protected excel sheet

 



Jazz
New User

Sep 27, 2006, 9:39 PM

Post #1 of 3 (3486 views)
How to edit cells of password protected excel sheet Can't Post

I have a working perl script which collects data from master excel sheet and populates rest of the sheets so as to keep them updated. But now there is a twist. Columns in rest of the sheets have been hidden and locked with password. I know the password but I am just not able to edit password protected area. I am using SpreadSheet::Parseexcel and Win32::OLE.
I was going through SpreadSheet::Writeexcel but that can be used to create new excel files as it is not exporting any Open API to use.


rork
User

Sep 28, 2006, 2:43 AM

Post #2 of 3 (3484 views)
Re: [Jazz] How to edit cells of password protected excel sheet [In reply to] Can't Post

Editing password protected data with Spreadsheet:ParseExcel still on the author todo list. Maybe you could mail the author of the module for more info and help him making it.
--
Don't reinvent the wheel, use it, abuse it or hack it.


Jazz
New User

Sep 28, 2006, 2:48 AM

Post #3 of 3 (3483 views)
Re: [rork] How to edit cells of password protected excel sheet [In reply to] Can't Post

Yeah...

As of now to acheive the same I have created 2 hidden and locked macros which are responsible for unprotecting and protecting rest of the sheets; and I run these macros from my Perl script using $Excel->Run("Macro-name");

Thanks

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives