my $test; my $totalrows = 1; for ($test=$worksheet->Range("A$totalrows:A$totalrows")->('Value');$test ne "";$totalrows++){ $test=$worksheet->Range("A$totalrows:A$totalrows")->('Value'); } $totalrows--;