Clicky

]Hi
i am new to the perl scripting.
I have requirement,We are creating the XLS report out of BO. using shell script we are scheduling the report  daily once and writning XLS report  into our linux directoty.after that we are simply emailing the report to the client.

BUT MY REQUIREMENT IS NOW  THAT XLS  REPORT  SHOULD BE PASSWORD PROTECTED BEFORE EMAILING TO THE CLIENT WITH OUT ZIPPING THE FILE.WHEN A CLIENT TRY TO OPEN THAT XLS REPORT FILE iT SHOULD PROMPT FOR THE PASSWORD .
cAN YOU PLEAS HELP ME with the perl script to provide this option.I would like to here solution from experts ASAP as this is top prioarity at the movemtn to us

.

asked 07/11/2010 01:05

pradeep666's gravatar image

pradeep666 ♦♦


12 Answers:

Dear,

You should use Spreadsheet::WriteExcel::Worksheet::SheetProtection;

After you could protect the excel file like : $worksheet->protect(mypassword);
 
http://search.cpan.org/~sriha/Spreadsheet-WriteExcel-Worksheet-SheetProtection-0.03/SheetProtection.pm

Best Regards

link

answered

MadShiva's gravatar image

MadShiva

theres also an option to password protect from within the application.  Under the "review" tab

link

answered 2010-07-11 at 23:50:28

oneofonex1's gravatar image

oneofonex1

oneofonex1:

I have asked how to solve ths solution using perl or any scripting.because the Xls report we are writing  in one of our linux directory not on windows location. This should be daily automate process  no manuval work need to be done.
If you can help me any of the perl script just to apply pasword protection on XLS report before sending an email.That would be appriciate
 

link

answered 2010-07-12 at 09:34:32

pradeep666's gravatar image

pradeep666

Hi Mad Shiva,
Thanks for your reply.your solution is near to my requirement but the problem is i just want to apply password at work book level not an worksheet or sell level.because my XLS report format should not impact bacasue of this password.I have found the below link which contains multiple options at excel level using perl script.

http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.37/lib/Spreadsheet/WriteExcel.pm#protect($password)

BUT MY PROBLEM I AM VERY NEW TO THE PERL could not able to crack solution for my requirement.

If any one can provide exact solution using perl script would really help full to me .

Thanks a ton in advance.

link

answered 2010-07-12 at 11:24:37

pradeep666's gravatar image

pradeep666

Dear,

No problem. I didn't have found a fonction that could do this or I can't quickly code this in perl, then I suggest you to use maybe the zip password and then you will have two bonus 1 you save traffic data and 2 mail storage :)

like "zip -P mypasswd foo.zip file1 file2"

Best Regards

link

answered 2010-07-12 at 11:33:49

MadShiva's gravatar image

MadShiva

Oups

Lol I forgot the next part :P sorry.

link

answered 2010-07-12 at 12:08:41

MadShiva's gravatar image

MadShiva

link

answered 2010-07-12 at 12:25:41

oneofonex1's gravatar image

oneofonex1



I agree that, even if you can protect the with password, the protection will be not usefull and will not be a real protection. (same apply with zip).

link

answered 2010-07-12 at 12:27:10

MadShiva's gravatar image

MadShiva

Hello Experts!!!

Can any EXPERT  has any idea to crack solution for the above question.If yes,Please provide me the script ...

To summarise:-
we are writing one report in XLS format in our Linux Dire....Before sending email tat xls report it should be password protected.when client clieck on that file basically it should prompt for the password...

Note:Zipped password protection file is not accepting by our client.

link

answered 2010-07-12 at 14:37:36

pradeep666's gravatar image

pradeep666

This is not the correct way to do thing. Password on xls file don't protect the file, and could be removed with a small macro.

Then why keep asking for something that is useless and don't accept the answer given by all the experts that say the same things ?

You should tell to your client that is not the good way to protect xls file. That's it.

link

answered 2010-07-25 at 15:16:10

MadShiva's gravatar image

MadShiva

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

link

answered 2010-09-03 at 01:45:14

suhasbharadwaj's gravatar image

suhasbharadwaj

Your answer
[hide preview]

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×1

Asked: 07/11/2010 01:05

Seen: 241 times

Last updated: 12/17/2011 05:21