|
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
pranav
|