Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Executing WIN32OLE program
Top Forums Shell Programming and Scripting Executing WIN32OLE program Post 302446617 by durden_tyler on Thursday 19th of August 2010 08:27:31 AM
Old 08-19-2010
Quote:
Originally Posted by suvenduperl
...
...
Code:
#!/usr/bin/perl -w
 
use strict;
use Win32::OLE qw(in with);
use Win32::OLE::Const 'Microsoft Excel';
 
$Win32::OLE::Warn = 3;                                # die on errors...
 
# get already active Excel application or open new
my $Excel = Win32::OLE->GetActiveObject('Excel.Application')
    || Win32::OLE->new('Excel.Application', 'Quit');  
 
# open Excel file
my $Book = $Excel->Workbooks->Open("u:/file.xls"); 
my $Book1 = $Excel->Workbooks->Open("u:/v3.xls");
 
 
# select worksheet number 1 (you can also select a worksheet by name)
my $Sheet = $Book->Worksheets(1);
my $Sheet1 = $Book1->Worksheets(1);
my $val1;
my $cnt=0;
my $line;
 
foreach my $row (1..3000)
{
 foreach my $col (1)
 {
  my $val;
  next unless defined $Sheet->Cells($row,1)->{'Value'};
  $val = $Sheet->Cells($row,1)->{'Value'};
  #findl($val);
  for($cnt=1;$cnt<=65536;$cnt++){
    $val1 = $Sheet1->Cells($cnt,1)->{'Value'};
    if ((defined $val1) && (index($val1,$val) != -1)){
      $line =$cnt if (!defined $line);
      $Sheet->Cells($row,2)->{'Value'}=1;
      last;
    }
 
 }
}
}
$Book->SaveAs ("u:/new_name.xls") ;
# clean up after ourselves
$Book->Close;
$Book1->Close;

What is the procedure to execute this script which uses WIN32 OLE
Looks like a Perl script to me, so I guess you execute it like you would a Perl script.

tyler_durden
 

10 More Discussions You Might Find Interesting

1. Programming

executing a program within a program

Read the title: how do i do it? (4 Replies)
Discussion started by: Gekko
4 Replies

2. UNIX for Dummies Questions & Answers

executing the su command from a java program.

Say in unix (AIX) m/c, I am logged in with s1 user and want to start process p1 with user credentials of s2. I can do manually in this way: #su - s2 #enter password for s2> somePassword $ p1 But all this I have to do through a java program. How to pass the password through program. One... (1 Reply)
Discussion started by: shailendrat
1 Replies

3. Programming

Executing an .ec program in different informix versions

Hi all, I tried writing an .ec program connecting to informix database from solaris platform Sun 5.7 informix version that i had to used when i compiled the program was 9.21.UC3 the binary when i ported solaris box with informix version 9.40.UC5 i am unable to run that i am encountering... (0 Replies)
Discussion started by: matrixmadhan
0 Replies

4. Programming

after executing execvp()... program hangs up

Hi , I m actually trying to implement pipes program,but after executing the execvp(),my program is getting hanged up :mad: Actaully i m getting the desired output expected from execvp()...but once results are displayed on the output screen ,program is getting hanged up values of... (3 Replies)
Discussion started by: Crab
3 Replies

5. Programming

Trubble in executing the cpp program...

I wrote a code like this....... #include <iostream> #include <stdio.h> #include <mysql.h> #include <string.h> #include <stdlib.h> using namespace std; #include "Connection.h" int main() { char *Host = (char *)"localhost"; char *Database =(char *)"sachin"; char... (3 Replies)
Discussion started by: ps_sach
3 Replies

6. Solaris

How to know the size of the program currently executing in memory

hey everybody, i am currently working on solaris 10 os on a m5000 server. my problem is when i want the exact size of a program in execution, i am unable to do it. earlier i thought the RSS field of prstat but because of its large size it cant be the size. pmap -x shows some output but it includes... (2 Replies)
Discussion started by: aryansheikh
2 Replies

7. Shell Programming and Scripting

Executing a Java Program

I am entirely new to shell scripting and would like to create a script to execute a java program called Main. I've already compiled it and placed the .java and .class files at /root/javaTest. Next I made a shell script that simply contained: java /root/javaTest/Main . I made the script... (2 Replies)
Discussion started by: hypnotic_meat
2 Replies

8. UNIX for Dummies Questions & Answers

executing a different program

What system calls or commands do I need to use in order to execute a different program from an already running process? (1 Reply)
Discussion started by: justOne21
1 Replies

9. Shell Programming and Scripting

AWK Program Not Executing On Linux with KSH

Overview: I have an AWK program that parses thru a database backup server log file and outputs ths following parameters SRNO DATE : TIME SIZE IN(KB) DATABASE NAME DUMP TYPE 1 May 16 2012: 13:30:00 6874 TestDB database 2 May 16 2012: 13:30:44 11462 master database Problem: This program has... (5 Replies)
Discussion started by: JolietJake
5 Replies

10. Programming

Error in executing the C program

Hello Friends, I have written a code for the unisex bathroom which makes a policy that when a woman is in the bathroom only other women may enter, but not men, and vice versa. This program consists of four functions which a user defines but these functions are not properly working while... (4 Replies)
Discussion started by: Ravi Tej
4 Replies

LEARN ABOUT DEBIAN

jzip

JZIP(6) 						 John's Z-code Interpreter Program						   JZIP(6)

NAME

       jzip - execute Infocom v1-5 and Inform v1-5 & v8 game files

SYNOPSIS

       jzip [ options ] z-file-name

DESCRIPTION

       jzip invokes the Z-code Interpreter.

REQUIREMENTS

       jzip  will  run	under  most  (if  not all) flavors of Unix, including AIX, Solaris, SunOS, HP/UX, Linux, Free/NetBSD, IRIX, NeXT Mach, DEC
       OSF/1, and others.

EDITING

       JZip now supports arrowkey editing in UNIX.

       Up/Down
	      selects the previous / next command in history

       Left/Right
	      moves the cursor over the line.

       Backspace
	      deletes

       Typing inserts under the cursor

OPTIONS

       -l n   lines in display

       -c n   columns in display

       -r n   text right margin (default = 1)

       -t n   text top margin (default = 0)

       -v     display version information

       -m     monochrome mode

       -y     set Tandy bit

       -s n   zmachine strict level, from 0 (none), 1 (report once, recommended) to 3.

ENVIRONMENT

       jzip looks for the environment variable INFOCOM_PATH and will use the path found there to look for the story file specified on the  command
       line if the story file cannot be found in the current directory.

CREDITS

       jzip is written and maintained by John Holder (j-holder@home.com), based on the ZIP v2.0 sources by Mark Howell and Olaf 'Olsen' Barthel.

AVAILABILITY

       The most recent version of jzip can be downloaded from one of:

       http://www.jzip.sourceforge.net/

       ftp://ifarchive.org/infocom/interpreters/zip/

FILES

       /usr/games/jzip
	      The Z-Code Interpreter Program

       /usr/lib/games/zfiles
	      Recommended location for Zcode files

RELATED USENET NEWSGROUPS

       Interactive Fiction (IF) authors should check out rec.arts.int-fiction, and IF players should check out rec.games.int-fiction.

2.1																	   JZIP(6)
All times are GMT -4. The time now is 06:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy