Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: How i can set the minimum value of a row 1?

by linuxer (Curate)
on Feb 16, 2021 at 21:13 UTC ( [id://11128473]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11128473]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (4)
As of 2024-03-28 20:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found