"be consistent" | |
PerlMonks |
Re: LastCol of an Excel spreadsheet as an alphanumeric using Win32::Oleby bmann (Priest) |
on Nov 23, 2005 at 00:27 UTC ( [id://510970]=note: print w/replies, xml ) | Need Help?? |
You can access a given cell by index, ie:
You can also get the last cell by using the SpecialCells method (caveat - Excel's notion of "Last Cell" is confusing at best):
HTH... BTW, I believe that valof is unnecessary in this case - perl sees the date as a date. If it is necessary, you'll need to change the call to ... = Win32::OLE::valof( $Sheet->... ) Update: Reading the other replies, I realize you want row 1. I thought you wanted the last cell. Added $row = 1
In Section
Seekers of Perl Wisdom
|
|