my $firstcolum = $Sheet->Range(
  $Sheet->Cells(1,1),
  $Sheet->Cells(1,$LastCol)
)->{'Value'};