Re[4]: Deleting a worksheet in Excel

[Chris Jones]

If the data is in a table with equal length rows you can create a 2-D array 
in your perl script then feed that array into the range in one call:

$range1 = "A1:Z100";  #determine the range by tracking the number of rows 
and columns when gathering the data.

$sheet->Range("$range1")->{Value} = [EMAIL PROTECTED]; #pass by reference
See the examples in the Activestate documentation Win32::OLE.
At 01:56 26/01/2005, you wrote:
 David,
Tuesday, January 25, 2005, 5:02:34 PM, You wrote:
HD>   Sergey,
HD> Thanks for the advice.  I'm  not too familiar with using variant 
arrays.  A little research showed that Perl does have variant arrays - 
Win32::OLE::Variant.  I did not find any good examples on
HD> the usage.  Do you have any insights on how to use variant arrays in 
populating an Excel workbook?

HD> Thanks,
HD> David
    I do not find in the docs anything about variant arrays in perl.
    Another way of accelerating interaction with excel may be getting
    all the data in text file with fields delimited with commas (or
    other symbol) and then open this file in excel with OpenText
    function (see Excel help)
  _______________________________________________
  Perl-Win32-Users mailing list
  Perl-Win32-Users@listserv.ActiveState.com
 To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs


--
С уважением,
 Сергей                            mailto:[EMAIL PROTECTED]
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Chris Jones, P.Eng.
14 Oneida Avenue
Toronto, ON M5J2E3
Tel. 416 203-7465
Fax. 416 946-1005 


_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs