Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > Perl Misc > Win32-OLE equivalent of write_row

Reply
Thread Tools

Win32-OLE equivalent of write_row

 
 
Richard S Beckett
Guest
Posts: n/a
 
      11-20-2003
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.
--
R.
GPLRank +79.699


 
Reply With Quote
 
 
 
 
James Willmore
Guest
Posts: n/a
 
      11-20-2003
On Thu, 20 Nov 2003 16:34:06 -0000
"Richard S Beckett" <(E-Mail Removed)> wrote:

> 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
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Warning:Xst:382 - Register A is equivalent to B mag VHDL 1 05-19-2005 05:10 PM
instancename of current entity/architecture -- equivalent to C++ this??? Eric Peers VHDL 2 11-18-2004 05:23 PM
VHDL equivalent of verilog trireg Sanjeev VHDL 4 07-23-2004 09:55 AM
equivalent types in different packages Lolo VHDL 3 09-22-2003 03:23 PM
Re: Image Scanning - TWAIN equivalent Brendan Duffy ASP .Net 0 07-24-2003 08:29 AM



Advertisments