cc
Subject
RE: w
The first sheet name is never changed from "Sheet1" to begin with because you
are trying to set it to a name with 37 characters. The
maximum sheet name length in Excel is 31 characters.
It would be nice if Excel returned an error if you try to assign an invalid
name, but it doesn't appear to
> Then delete all the sheets that start with "sheet"
>
> $SheetTabName = $Book-> Worksheets($_)->{Name};
> foreach ( 1...$SheetCnt)
> {
> $SheetTabName = $Book-> Worksheets($_)->{Name};
> if ( $SheetTabName =~ /^sheet/i )
> {
> $Book->Worksheets
investigation.
Thanks,
David
-Original Message-
From: Dave Kazatsky [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 04, 2005 1:47 PM
To: Hsu, David
Cc: Perl-Win32-Users@listserv.ActiveState.com;
[EMAIL PROTECTED]
Subject: RE: Win32:OLE Excel
David,
I have a script with almost the exact same
atsky [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 04, 2005 1:47 PM
To: Hsu, David
Cc: Perl-Win32-Users@listserv.ActiveState.com;
[EMAIL PROTECTED]
Subject: RE: Win32:OLE Excel
David,
I have a script with almost the exact same code and it works correctly.
Try removing the parens from your add
EMAIL PROTECTED]
08/04/2005 01:17 PM
To: "Ken Barker" <[EMAIL PROTECTED]>, Perl-Win32-Users@listserv.ActiveState.com
cc:
Subject: RE: Win32:OLE Excel
Ken,
I am using Win32::OLE. Add_worksheet uses the Spreadsheet:WriteExcel
module.
Thanks,
David
-Original Message-
Ken,
I am using Win32::OLE. Add_worksheet uses the Spreadsheet:WriteExcel
module.
Thanks,
David
-Original Message-
From: Ken Barker [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 04, 2005 12:07 PM
To: Hsu, David; Perl-Win32-Users@listserv.ActiveState.com
Subject: RE: Win32:OLE Excel
Hsu, David wrote:
> Hi,
> Does someone know of another method of naming the Excel sheets?
> Currently I am using:
> ...
> $Worksheet = $Workbook->Worksheets()->Add();
> $Worksheet->{Name} = "test $i";
> ...
>
> The sheet names are still "Sheet1", "Sheet2", etc...
my $workbook = $Excel->Workbooks-
Try
$ws1 = $workbook->add_worksheet('worksheetname');
Ken Barker
IT Lead
Americall Group, Inc
314-213-7927
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
Hsu, David
Sent: Thursday, August 04, 2005 10:23 AM
To: Perl-Win32-Users@listserv
> From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED]
> Subject: Win32:OLE Excel last row question.
> This line successfully gives me the last used row in a populated
> spreadsheet:
>
> my $LastRow = $sheet->UsedRange->Find({What=>"*",
> SearchDirection=>xlPrevious, SearchOrder=>xlByRows})-
> Hi,
>
> does soemone know how I can get the type of an Excel-Sheet
> via perl. I have to know whether a Sheet is a 'Chart' or a
> 'Worksheet'.
>
> In Visual Basic there is The 'TypeName'-Function. But I
> don't get this Function to call from my perl
>
> Cheers
> Armin
Hi Armin,
If you us
ckett Richard-qswi266'; [EMAIL PROTECTED]
Subject: RE: Win32-OLE excel cell reference.
> From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED]
> Subject: Win32-OLE excel cell reference.
> It seems that the Range command likes data like (A14), or
> (A14:B26), and I am happy with
Beckett Richard-qswi266 wrote:
> Guys,
>
> I'm struggling with the syntax to point to the cells that I want to use in
> Excel.
>
> It seems that the Range command likes data like (A14), or (A14:B26), and I
> am happy with this.
>
> My problem occurrs when I only have numeric data to work with,
> From: Beckett Richard-qswi266 [mailto:[EMAIL PROTECTED]
> Subject: Win32-OLE excel cell reference.
> It seems that the Range command likes data like (A14), or
> (A14:B26), and I am happy with this.
>
> My problem occurrs when I only have numeric data to work
> with, because of incremented
> From: Ross Matt-QMR000 [mailto:[EMAIL PROTECTED]
> Subject: RE: Win32-OLE excel cell reference.
> by no means did mean anything negative about what you
> wrote in reply. You have ALWAYS been very helpful to me and
> others with your posts.
No worries. I didn't ta
--8<---
If you'll notice, the code provided was wrapped in <% %> which indicates
SERVER side execution.
--8<---
Feel the need for a little defence on my part ;)
There's no point in trying to execute server side code in the faint hope
that it will open your local file. I've
16 matches
Mail list logo
