Spreadsheet-WriteExcel-Worksheet-SheetProtection - Reg: Workbook Protection

Posted on Tue Jan 22 16:33:17 2008 by pranav
Reg: Workbook Protection
Platform: Linux Perl5.6 I have a module in which i am creating an excel sheet, doing formatting and then writing the data i +nto it, now I have to protect the workbook with a password in a separate module. I thought of using the Spreadsheet::WriteExcel protect method for worksheet but in that scenario i +am facing two shortcomings 1) Spreadsheet::WriteExcel protect is a sheet level protection in which user would only be able to +read the data but he can view it. 2) Also the other thing is if I have to open the workbook and protect it and I use Spreadsheet::Wri +teExcel->new method to obtain the workbook handle I fear i would be loosing all the data and the f +ormatting . Can somebody guide me what should i do to overcome the issue which I am facing. Regards
Write a response