my $UsedRows = 0+$Sheet->UsedRange->{Rows}->{Count}; my $FirstRow = 0+$Sheet->UsedRange->Rows(1)->{Row}; my $LastRow = $FirstRow + $UsedRows - 1; my $UsedCols = 0+$Sheet->UsedRange->{Columns}->{Count}; my $FirstCol = 0+$Sheet->UsedRange->Columns(1)->{Column}; my $LastCol = $FirstCol + $UsedCols - 1;