good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Re^2: Make existing excel file password protectedby dasgar (Priest) |
on Nov 03, 2017 at 20:17 UTC ( [id://1202722]=note: print w/replies, xml ) | Need Help?? |
If you're on a Windows system and have Excel installed, you can use Win32::OLE to automate Excel. Anything that you can do manually in Excel is possible to do via Win32::OLE. But this is a case of Perl automating an external program (Excel). Personally I have not used any of the modules that attempt to manipulate Excel files without using Excel itself, so I can't comment on their capabilities or suggest an alternative.
In Section
Seekers of Perl Wisdom
|
|