http://qs321.pair.com?node_id=11128473


in reply to How i can set the minimum value of a row 1?

Assuming the method row_range() returns two or more values and you are only interested in the second one, you could use a slice:

my $row_min = 1; my $row_max = ( $worksheet->row_range() )[1];

But maybe it makes more sense to read the module's documentation. Maybe there is a dedicated method to return the value for row_max.

edit:

Or simply overwrite $row_min after the call of row_range().

my ( $row_min, $row_max ) = $worksheet->row_range(); $row_min = 1;

Replies are listed 'Best First'.
Re^2: How i can set the minimum value of a row 1?
by chandantul (Scribe) on Feb 18, 2021 at 01:53 UTC

    Thanks . This resolved the issue