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