"be consistent" | |
PerlMonks |
Re: Excel to Perlby cacharbe (Curate) |
on Mar 20, 2002 at 19:23 UTC ( [id://153094]=note: print w/replies, xml ) | Need Help?? |
Alright, I'll finish the Tutorial and get it up by the week-end. Read my Scratch Pad for a complete discussion on getting data from and manipulating data in an excel worksheet using Win32::OLE. Honestly, if you're going to be opening the workbooks anyway, there is no reason to use two scripts to accomplish this task, just iterate through the Sheets object of each workbook starting from the 1 position. Otherwise use the SaveAs function of the Worksheet object C-. Update: I thought I should make a slight clarification about iterating through the Worksheets set based on sheet count. I was trying to say that the Worksheets object is 1 based, not 0 based. If, indeed, you wanted to skip the first work sheet, you would start with 2.
In Section
Seekers of Perl Wisdom
|
|