Just going through the same thing... it seems you need to pass \@data
instead of @data.
Heiko
--
-- PREVINET S.p.A. [EMAIL PROTECTED]
-- Via Marocchesa, 14 ph x39-041-5907073
-- I-31021 Mogliano V.to (TV) fax x39-041-5907087
-- ITALY
>-----Original Message-----
>From: Mark Sutfin [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, November 29, 2000 10:50 PM
>To: '[EMAIL PROTECTED]'
>Subject: Win32::OLE and {Value} = a list
>
>
>I need to populate an Excel worksheet with some values (a, b,
>c). This code
>works fine....
>
>$Range = $Worksheet->Range("A1:A3");
>$Range->{Value} = ("a", "b", "c");
>$Workbook->SaveAs( $outfile );
>
>However, I'm retrieving the values from text files recursively
>(multiple
>files), so I need to use a list variable in place of coding
>the values... I
>tried replacing the hardcoded list with an array, but it
>doesn't work. It
>seems to treat "@data" as a scalar and passes the number of elements to
>Excel..
>
>$Range = $Worksheet->Range("A1:A3");
>$Range->{Value} = @data; #
>(@data) etc, etc,
>etc
>$Workbook->SaveAs( $outfile );
>
>I've been thru the docs and Chapter 5: Automation of Dave
>Roth's book, Win32
>Perl Programming, but don't see any examples. Any ideas would
>be greatly
>appreciated..
>
>Perhaps the values need to be contained in a hash, but I
>really have no idea
>what the syntax might look like...
>
>Regards,
>
>Mark D. Sutfin
>Tech. Mgr. App. & Sys. Development
>Affinity Group Inc.
>(303) 728-7474
>
>_______________________________________________
>Perl-Win32-Admin mailing list
>[EMAIL PROTECTED]
>http://listserv.ActiveState.com/mailman/listinfo/perl-win32-admin
>
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-admin
