Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Apply Password to already Written XLS File.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Apply Password to already Written XLS File.
# 1  
Old 07-14-2010
Apply Password to already Written XLS File.
I need to apply password protection to a xls file.I had looked at SpreadSheet::WriteExcel but problem being i dont want to write the contents of file again as the formatting the file would be a pain.

Is there way in which i write a entire file in one go , something like this

Code:
$sp->write(XLSFile);

and then just apply the
Code:
$sp->protect('password');



---------- Post updated 07-14-10 at 09:31 AM ---------- Previous update was 07-13-10 at 05:32 PM ----------

Anyone ?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

HI, I have multiple files per dept in folder for eg : In a folder File1_Dept100.xls File2_Dept100.xls File3_Dept100.xls File1_Dept200.xls File2_Dept200.xls File3_Dept200.xls Output should be : Dept100.xls which has File1, File2, File3 in different tabs Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies

2. Shell Programming and Scripting

Apply file permission

Hi All, I would like to read the permission from a file and wanted to apply the same permission to another file. say for example, f1 755 first...i have to read the permission type (which is differ for each file) and need to apply the same for f2 a1 666 i have to get this... (5 Replies)
Discussion started by: karthi_mrkg
5 Replies

3. UNIX for Advanced & Expert Users

How to copy a binary file while the file is being written to by another process

Hello, Can I copy a binary file while the file is being written to by another process? Another process (program) “P1” creates and opens (for writing) binary file “ABC” on local disk. Process P1 continuously write into ABC file every couple of seconds, adding 512-byte blocks of data. ABC file... (1 Reply)
Discussion started by: mbuki
1 Replies

4. UNIX for Advanced & Expert Users

ldapsearch in monitoring script without bind password written in script

Hi I do a very simple monitoring of our OpenLDAP (runs in cronjob and generate alerts if unsuccessfull) $ ldapsearch -h hostname.domain -D "cn=monitor_user,ou=People,dc=organisation" -w "password" -b "dc=organisation" -x "(&(cn=monitor_user)(ou=People))" dn | grep -v version dn:... (4 Replies)
Discussion started by: slashdotweenie
4 Replies

5. UNIX for Dummies Questions & Answers

12. If an ‘88’ Record with BAI Code ‘902’ was found on input file and not written to Output file, re

This is my input file like this 03,105581,,015,+00000416418,,,901,+00000000148,,,922,+00000000354,,/ 49,+00000000000416920,00002/ 03,5313236,,015,+00231036992,,,045,+00231036992,,,901,+00000048428,,/ 88,100,+0000000000000,0000000,,400,+0000000000000,0000000,/ 88,902,+0000000079077,,/... (0 Replies)
Discussion started by: sgoud
0 Replies

6. Shell Programming and Scripting

Re-apply the file permission

Hi, I having an issue with file permission. To fix it I need to read the file's existing permission and re-apply the same permission to the file. This has to be done for every single file under a mount point. I'm novice in scripting. Help me with this in shell scripting. # ls -l /dev/null... (10 Replies)
Discussion started by: agent001
10 Replies

7. Solaris

Apply password in some command

hello guys, I need some command,script or anythng which will help me to prompt for a password if I give some common unix command. We need this command to restrict the access to few users only like for tip command. That wenever i give TIP command, it will ask for password and only autherized users... (1 Reply)
Discussion started by: harpreetrekhi
1 Replies

8. Shell Programming and Scripting

converting xls file to txt file and xls to csv

I need to convert an excel file into a text file and an excel file into a CSV file.. any code to do that is appreciated thanks (6 Replies)
Discussion started by: bandar007
6 Replies

9. Shell Programming and Scripting

Checking a file is not being written to

Hello All I am attempting to write a shell script (bourne shell script) which will copy a tar'd and compressed file from a directory to a staging area but will not know whether the file is still open for write since files are being ftp's to my site at random times during the day. Once I am... (14 Replies)
Discussion started by: kanejm
14 Replies

10. UNIX for Dummies Questions & Answers

File being used/written

Hello, Which command in unix can tell whether a file is being used/written by another process. e.g. If one process is copying a very big file in some directory and there is another cronjob process which checks for a new file and in this directory and process the file. I want to check, if the... (4 Replies)
Discussion started by: sanjay92
4 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

dbix::password

Password(3pm)						User Contributed Perl Documentation					     Password(3pm)

NAME

       DBIx::Password - Allows you to create a global password file for DB passwords

SYNOPSIS

	 use DBIx::Password;
	 my $dbh = DBIx::Password->connect($user);
	 my $dbh = DBIx::Password->connect_cached($user);
	 $dbh->getDriver;
	 DBIx::Password::getDriver($user);
	 DBIx::Password::checkVirtualUser($user);

	 DBIx::Password::clearConfig();
	 DBIx::Password::readConfig("$ENV{HOME}/.my.secret.file");

DESCRIPTION

       Don't you hate keeping track of database passwords and such throughout your scripts? How about the problem of changing those passwords on a
       mass scale? This module is one possible solution. It stores all your virtual users and data in /etc/dbix-password.conf.	For each user you
       need to specify the database module to use, the database connect string, the username and the password.	You will have to give a name to
       this virtual user.  You can add as many as you like.

       I would recommend that if you are only using this with web applications that you change the final permissions on this package after it is
       installed in site_perl such that only the webserver can read it.

       A method called getDriver has been added so that you can determine what driver is being used (handy for working out database indepence
       issues).

       If you want to find out if the virtual user is valid, you can call the class method checkVirtualUser().	It returns true(1) if the
       username is valid, and zero if not.

       Once your are done you can use the connect method (or the connect_cache method) that comes with DBIx-Password and just specify one of the
       virtual users you defined while making the module.

       BTW I learned the bless hack that is used from Apache::DBI so some credit should go to the authors of that module.  This is a rewrite of
       the module Tangent::DB that I did for slashcode.

       If your program does not need the system-wide information stored in the /etc/dbix-password.conf file, you may use the clearConfig() and
       readConfig() functions to get the data from another source.  At any time, readConfig() may also be used to merge the data from another file
       into the currently-loaded configuration.

       Hope you enjoy it.

HOME

       To find out more information look at: http://www.tangent.org/DBIx-Password/

AUTHOR

       Brian Aker, brian@tangent.org

SEE ALSO

       perl(1). DBI(3).

perl v5.10.0							    2009-05-09							     Password(3pm)