No such thing as a small change | |
PerlMonks |
Excel Save & Cell Protectby Anonymous Monk |
on Sep 11, 2003 at 08:23 UTC ( [id://290615]=perlquestion: print w/replies, xml ) | Need Help?? |
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
Answers to either of the following will be much appreciated. Excel Save I want to overwrite an existing Excel spreadsheet without being asked the question 'Do I really want to do this'. I could delete the file before overwriting but I wondered if there was an option for the $excel->Workbooks(1)->SaveAs(filename)that allowed this. Cell Protection I want to protect cells of an Excel spreadsheet that I create so that when using Excel to read the spreadsheet these cells cannot be modified. How can this be done?
Back to
Seekers of Perl Wisdom
|
|