Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Re^3: How to modify column in WriteExcel?

by hdb (Monsignor)
on Mar 13, 2019 at 10:32 UTC ( [id://1231210]=note: print w/replies, xml ) Need Help??

in reply to Re^2: How to modify column in WriteExcel?
in thread How to modify column in WriteExcel?

If this is the output of print Dumper $url; then you need to use $url->[0][0] instead of $url->[0] (the latter being the same as ${$url}[0]).

Update: or ${${$url}[0]}[0] if you prefer.

Replies are listed 'Best First'.
Re^4: How to modify column in WriteExcel?
by vserzh (Novice) on Mar 13, 2019 at 10:45 UTC
    Yes, that output and thank you $url->[0][0] is works, link are valid now. Could you explain me why is two pointers here [0][0]? And another question can I use for/foreach to modify every row in that column?

      fetchall_arrayref returns all rows of your query in an array reference (first level of dereferencing needed) and each row again is an array reference (even when there is only one column) which is the second level of dereferencing. If you want so, you ask for a table, so you get a two-dimensional object...

        Oh, I get the point. Thank you for explanation and for Data::Dumper too, very useful thing :)

Log In?

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

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2024-04-13 09:57 GMT
Find Nodes?
    Voting Booth?

    No recent polls found