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} = [EM
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 ha
Excel workbook?
Thanks,
David
-Original Message-
From: Сергей Черниенко [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 3:15 AM
To: Hsu, David
Cc: Perl-Win32-Users@listserv.ActiveState.com
Subject: Re[2]: Deleting a worksheet in Excel
Здравствуйте David,
Monday, January 24, 20
Здравствуйте David,
Monday, January 24, 2005, 8:33:56 PM, Вы написали:
HD> Fred,
HD> Thanks, that works as well. I used Сергей one-liner.
HD> On another topic concerning Excel. Do you ever get:
HD> HTTP/1.1 502 Gateway Error Server: Microsoft-IIS/5.0 Date: Wed, 19 Jan 2005
19:03:35 GMT Cont
[EMAIL PROTECTED] wrote:
Hi;
Don't most OO structures require
constructor
and destructor methods? Seems to me this is OK for OO. Requiring the
Workbook
to delete the Worksheet leads to a different problem...that of a
WorkBook
with no Worksheets. Since the raison d'etre for a WorkBook is as
Perl-Win32-Users@listserv.ActiveState.com
cc
Subject
Re: Deleting a worksheet in Excel
Hsu, David wrote:
> Hi,
> Can someone let me know the syntax of deleting a worksheet in an Excel
> workbook. I am using Win32::OLE.
> I've tried:
> $Workbook->Worksheets{9}.Delete;
>
> Tha
24/2005 05:29 PM
To
Perl-Win32-Users@listserv.ActiveState.com
cc
Subject
Re: Deleting a worksheet in Excel
Hsu, David wrote:
> Hi,
> Can someone let me know the syntax of deleting a worksheet in an Excel
> workbook. I am using Win32::OLE.
> I've tried:
> $Workbook
Hsu, David wrote:
Hi,
Can someone let me know the syntax of deleting a worksheet in an Excel
workbook. I am using Win32::OLE.
I've tried:
$Workbook->Worksheets{9}.Delete;
Thanks,
David
This is an aside, not an attempt to answer your question, but:
Doesn't anyone think it's a bit odd to tell a W
x27;s a problem I'm working on, but thought that you might have encountered it.
David
-Original Message-
From: Fred Govier [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 12:37 PM
To: Hsu, David
Cc: Perl-Win32-Users@listserv.ActiveState.com
Subject: Re: Deleting a worksheet
This works for me:
my $Sheet = $Workbook->Worksheets(9); # select worksheet
number 9
$Sheet->Delete;
Hsu, David wrote:
Can someone let me know the syntax of deleting a worksheet in an Excel
workbook. I am using Win32::OLE.
I've tried:
$Workbook->Worksheets{9}.Delete;
_
That was it.
Thanks.
-Original Message-
From: Сергей Черниенко [mailto:[EMAIL PROTECTED]
Sent: Monday, January 24, 2005 11:25 AM
To: Hsu, David
Cc: Perl-Win32-Users@listserv.ActiveState.com
Subject: Re: Deleting a worksheet in Excel
Здравствуйте David,
Monday, January 24, 2005, 5:39
Здравствуйте David,
Monday, January 24, 2005, 5:39:01 PM, Вы написали:
HD> Hi,
HD> Can someone let me know the syntax of deleting a worksheet in an Excel
HD> workbook. I am using Win32::OLE.
HD> I've tried:
$Workbook->>Worksheets{9}.Delete;
HD> Thanks,
HD> David
try
$Workbook->Worksheets(9)
Title: Message
Hi,
Can someone let me know the syntax of deleting a
worksheet in an Excel workbook. I am using
Win32::OLE.
I've tried:
$Workbook->Worksheets{9}.Delete;
Thanks,
David
___
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.Activ
13 matches
Mail list logo
