Win32-OLE equivalent of write_row

[Richard S Beckett]

Guys,

Using Spreadsheet::WriteExcel, I can insert an array of unknown length into
a row with:

$page->write_row(0, 5, $temp);
Where $temp = \@temp;

Is the same thing possible with Win32::OLE?

When I tried:
$page -> Range ("F1:AZ1") -> {Value} = [@temp];

I got #N/A in the last few cells.

Thanks.

 

[James Willmore]

Guys,

and Gals

Using Spreadsheet::WriteExcel, I can insert an array of unknown
length into a row with:

$page->write_row(0, 5, $temp);
Where $temp = \@temp;

Is the same thing possible with Win32::OLE?

When I tried:
$page -> Range ("F1:AZ1") -> {Value} = [@temp];

I got #N/A in the last few cells.

This *may* be nothing more than cell width. Have you expanded the
cells in question to see if the data is there?

*If* you have, then you *might* need to loop through the @temp array
and fill each cell individually.

Just my $0.02 ...

HTH

--
Jim

Copyright notice: all code written by the author in this post is
released under the GPL. http://www.gnu.org/licenses/gpl.txt
for more information.

a fortune quote ...
Remember: Silly is a state of Mind, Stupid is a way of Life.
<-- Dave Butler