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
