Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^5: How to modify column in WriteExcel?

by hdb (Monsignor)
on Mar 13, 2019 at 12:03 UTC ( #1231219=note: print w/replies, xml ) Need Help??


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

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

Replies are listed 'Best First'.
Re^6: How to modify column in WriteExcel?
by vserzh (Novice) on Mar 13, 2019 at 12:18 UTC
    Oh, I get the point. Thank you for explanation and for Data::Dumper too, very useful thing :)

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (3)
As of 2021-04-11 18:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?