in reply to change value in run time

It is not what you asked (I see someone else has stepped in there) but are you sure you want to assign elements of @$retrieve_ref? I thought fetchall_arrayref returned a reference to an array where each element was a reference to an array of row values. e.g., for select * from table where table has 2 fields in it I thought fetchall_arrayref returns:

  [[row1field1, row1field2], [row2field1, row2field2]...]

[download]

Replies are listed 'Best First'.
Re^2: change value in run time
by xiaoyafeng (Deacon) on Oct 23, 2008 at 16:30 UTC
    but are you sure you want to assign elements of @$retrieve_ref?
    ah, yes. Because you can assign a array reference to a excel Range object like this: 
    $sheet->Range('A1:B1')->{'Value'} = [$name, $last_time];

    [download]

    I am trying to improve my English skills, if you see a mistake please feel free to reply or /msg me a correction
[reply]
[d/l]

In Section Seekers of Perl Wisdom