in reply to Getting the Column Header name in Excel using Win32 OLE

This seems to work ok. 
my $firstcolum = $Sheet->Range(
  $Sheet->Cells(1,1),
  $Sheet->Cells(1,$LastCol)
)->{'Value'};

[download]
I find your variable names a bit confusing. ymmv. :-)

In Section Seekers of Perl Wisdom