Click here to see examples of what you are looking for
-Dilip
dilipkvarma
Last Activity: Jul 31 '07, 04:04 AM
Joined: Jul 17 '07
Location:
-
It is very obvious.
The Win32:OLE module allows your code to talk to any MS Windows OLE application that is available on the system from where you are running your code.
This clearly indicates that
* You must be running your code from an MS Windows machine
* You must have the OLE application (in this case Excel) setup on your machine
An easier solution would be to write the data in...Leave a comment:
-
I do not think that there is such a limitation for Excel.
Please try this code. Look at the output of the command and check the character count in the resulting Excel sheet.
[CODE=perl]
use Win32::OLE;
my $Excel = Win32::OLE->new('Excel.App lication');
$Excel->{SheetsInNewWo rkbook} = 1;
$Excel->{Visible} = 1;
my $Book = $Excel->Workbooks->Add;
my $Sheet = $Book->Worksheets(1 );...Leave a comment:
-
No worries Miller.
Thanks for the links (Beginning Perl) and thank you very much for your time and efforts.
Catch you later with some other PERL query
DilipLeave a comment:
-
It is an interesting question. In fact, i am relatively new to PERL and did not have any formal training on PERL. But I am reasonably good in Visual Basic and I used to do these using VBA. And my current assignment requires me to do the above mentioned manipulation using PERL. To get this done, I managed to find some sample PERL scripts that manipulates Excel data. And from there onwards, I was just trying to convert the VBA code into PERL. Since...Leave a comment:
-
Thank you for quick reply, but my site does not have that package installed and I do not have permissions to install it.
DilipLeave a comment:
-
Hi Miller,
Thank you for pointing out my mistake, I accept that and my sincere apologies.
Please find below the compilable code:
[CODE=perl]
use Win32::OLE;
############### ############### ###############
# Create Excel instance
############### ############### ###############
# Start Excel and make it visible
$Excel = Win32::OLE->new('Excel.App lication');
$Excel->{SheetsInNewWo rkbook}...Leave a comment:
-
Win32::OLE Excel - Running Subtotal command
Hi All,
I am trying to create a subtotal in an Excel sheet through Perl script. Some how I am not able to make it work.
Here is what I wrote
[CODE=perl]
$Sheet->Activate;
$Range = $Sheet->Range("A2:C$Ro w");
$Range->Select;
@TotalList = (2, 3);
$Excel->Selection->Subtotal({Grou pBy => 1, Function => xlCount, TotalList => (2)});
[/COD...
No activity results to display
Leave a comment: