Help for this page

Select Code to Download


  1. 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;