Re: LastCol of an Excel spreadsheet as an alphanumeric using Win32::Ole

[bmann]

in reply to LastCol of an Excel spreadsheet as an alphanumeric using Win32::Ole

You can access a given cell by index, ie:

my $row = 1;
my $date = $Sheet->Cells( $row, $LastCol )->{ Value };

You can also get the last cell by using the SpecialCells method (caveat - Excel's notion of "Last Cell" is confusing at best):

my $date = $excel->ActiveCell->SpecialCells( xlLastCell )->{Value};
# assuming you've imported Excel's constants with Win32::OLE::Const

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