Eventually, I figured it out.
use strict;
use warnings;
use Win32::OLE;
my $Excel = Win32::OLE->new('Excel.Application');
my $WorkBook = $Excel->Workbooks->Add;
my $freeze_panes = $WorkBook->ActiveSheet->Range("B3")->Select;
$Excel->ActiveWindow->{FreezePanes} = 1;
----- Original Message -----
From: "Vladimir Lemberg" <[EMAIL PROTECTED]>
To: <beginners@perl.org>
Sent: Tuesday, March 27, 2007 4:49 PM
Subject: Re: Win32::OLE packages
Hi to all,
Sorry for asking the same question.. I beleave sombody have used win32:OLE
module.
From the Module description:
OLE Automation brings VisualBasic like scripting capabilities and offers
powerful extensibility and the ability to control many Win32 applications
from Perl scripts.
I need to Freeze Panes in my excel document.
In VisualBasic this will look like this:
Range("B2409").Select
ActiveWindow.FreezePanes = True
Do you know how to translate it on Perl language?
For instance Range select looks like this:
my $range = $xlBook->ActiveSheet->Range("A2:B2");
Thanks in advance,
Vladimir
----- Original Message -----
From: "Vladimir Lemberg" <[EMAIL PROTECTED]>
To: <beginners@perl.org>
Sent: Monday, March 26, 2007 4:22 PM
Subject: Win32::OLE packages
Hello All,
Does anybody know which package in Win32:OLE will Freeze Panes and call
Format Report method in excel document?
Thanks in advance,
Vladimir
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
