in reply to inserting a perl array into an Excel doc with OLE

Change this to anonymous array and it will work fine: 
$sheet1 -> Range("A1:D4") -> {Value} = [@average_values_table];

[download]

Regards,
s++ą  ł˝ ął. Ş ş şą Żľ ľą˛ş ą ŻĽąş.}++y~-~?-{~/s**$_*ee

Replies are listed 'Best First'.
Re^2: inserting a perl array into an Excel doc with OLE
by Anonymous Monk on Oct 11, 2008 at 08:23 UTC
    ahhhhh. brilliant! thanks. Would you care to explain why an anonymous array is used please?
[reply]
      I used the above as well, and it worked great.
[reply]
Re^2: inserting a perl array into an Excel doc with OLE
by HelenCr (Monk) on Jan 13, 2013 at 14:28 UTC

    I think the right code is:

    $sheet1 -> Range("A1:D4") -> {Value} = \@average_values_table;

    (In other words, referring to the array's address).

    If you use an anonymous array, you're needlessly creating a new array.

[reply]
[d/l]

In Section Seekers of Perl Wisdom