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


You should be able to get the value as follows (without converting to A1 notation): 
    $lastdate = $Sheet->Cells(1, $LastCol)->{Value};

[download]

--
John.

  • Comment on Re: LastCol of an Excel spreadsheet as an alphanumeric using Win32::Ole
  • Download Code

In Section Seekers of Perl Wisdom