Connecting Tech Pros Worldwide Help | Site Map

need to programatically password protect for Excel file

  #1  
Old May 15th, 2009, 01:20 PM
Newbie
 
Join Date: May 2009
Posts: 2
I have created an Excel file using PYExcelerator API. I need to programatically password protect
the file so that it can't be read unless the password is entered.

working in Linux environment.


Any code examples?
Python

Last edited by debasisdas; May 16th, 2009 at 07:46 PM. Reason: moved
  #2  
Old May 19th, 2009, 06:56 PM
Moderator
 
Join Date: Mar 2006
Posts: 1,103

re: need to programatically password protect for Excel file


Can you password zip the file?
  #3  
Old May 20th, 2009, 05:41 AM
Newbie
 
Join Date: May 2009
Posts: 2

re: need to programatically password protect for Excel file


I have tried to Password the ZIP file

zipFile=zipfile.ZipFile(zipFileName,"w",zipfile.ZI P_DEFLATED)
.
.
.
zipFile.setpassword("kishore123")

but i am not sure why it is not working.
when i tried to open the Zip it is simply opening with out prompting for Password

Please suggest me

Thanks
Kishore
  #4  
Old June 26th, 2009, 07:18 PM
Newbie
 
Join Date: Jun 2009
Posts: 6

re: need to programatically password protect for Excel file


Hi there,

Whenever you password protect a zip file (doesn't matter the method), whenever you open up the zip file, it won't prompt you for a password (unlike with any other password protected file), but when you unzip or try to open a file in the zip file, it will prompt you for a password.

Hope this is helpful,
Kind Regards
Reply


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need example: Add password to Excel file. vbMark answers 2 December 2nd, 2005 07:45 PM