Re: Question about writing to excel file

Hi All, I think I found the answer (checking at previous posts), I think I am going to use Spreadsheet::WriteExcel. Thanks, Alok --- Alok Bhatt <[EMAIL PROTECTED]> wrote: > Hi All, > > I am writing a script (needless to mention that it > is > in perl :)), that would r

Question about writing to excel file

Hi All, I am writing a script (needless to mention that it is in perl :)), that would read an excel file and save a copy of one of the sheet as another excel file and do processing on it. (Adding formats..etc). Can u please tell me which would be the best module to handle this. I have searched th

Running perl code through ssh

Hi All, I need to run a perl script, which ssh'es to another box and has to run some code, which is given in the present script and return some value. Is that possible? Net::SSH doesnt seem to be the answer as it merely runs a command at the remote host. Thanks, Alok ___

Keeping track of a variable

Hi All, Can someone please tell me how do we keep track of a variable. ie Whenever a particular variable is accessed (printed, incremented etc.), a counter should increase, so that we can know how many times it has been accesssed. Thanks in Advance, Regards, Alok

Re: DBD for SQL Server?

--- Richard Crawford <[EMAIL PROTECTED]> wrote: > Is there a DBD for SQL Server so that I can connect > to our SQL Server > 2000 database with DBI? I've hunted all over CPAN > but I can't seem to > find one. Windows uses the Open Database Connectivity (ODBC) Model. You can connect to an MS-SQL

Re: Array in a regexp

--- Alok Bhatt <[EMAIL PROTECTED]> wrote: > > --- Jason Dusek <[EMAIL PROTECTED]> wrote: > > Hi List, > > But if I have a long list of suffixes, then I > would > > like to store the > > suffixes in an array, and then evaluate the array > in >

Re: Array in a regexp

--- Jason Dusek <[EMAIL PROTECTED]> wrote: > Hi List, > But if I have a long list of suffixes, then I would > like to store the > suffixes in an array, and then evaluate the array in > my regular > expression. What does this? I've tried: > >@SUFF = (fish,foul); >foreach (@ARGV) { >

Re: Perl Scripts examples

> I am new to perl. Can somebody tell me about some > link on internet from > where i can find some scripts to begin with so that > i can start getting > style of writing code in perl. I have gone through > o'reilly book and is > looking for some practical exercises. Hi, the examples from Learn

Re: Variable "$some_var" will not stay shared

> > This is coz you have defined $arg1 and $arg2 to be > local, hence when u > > defined a new subroutine, a new sope is defined, > and is beyond the scope of > > $arg1 and $arg2. Hence the error. > But wait, I thought 'my' variables were 'local to > the enclosing > block'. If you look at the encl

Re: System (" ");

--- Adrian Farrell <[EMAIL PROTECTED]> wrote: > Hi, Hi Adrian, > system("date|awk '{print $2,$3}'"); > I get: > awk: syntax error near line 1 > awk: illegal statement near line 1 $1 to $10 are special variables in perl, which gets filled up, when you match a regex. You should escape them, so that

Re: Date problem

Hi, Thanks everyone for the answer. So silly of me. Didnt check the docs :$ --- Patrick Heffernan <[EMAIL PROTECTED]> wrote: > > On Mon, 26 Apr 2004 06:07:03 -0700 (PDT) > Alok Bhatt hammered out: > > > I am facing this strange problem related to dates. > &g

Date problem

Hi All, I am facing this strange problem related to dates. When I print the date using the system's date command, it prints correctly. But when I do the same using localtime, it shows the month as wrong (1 month previous. bash-2.03$ perl -e '@a=localtime; print "@a\n"' 18 4 8 26 3 104 1 116 0

Re: Help in using Modules

o any of those directories. If the module needs to be installed, You will have to use the proper process to install the module. Just untar the module and read the README file. But I think, it should not be that difficult. Alok Bhatt __ Do you Yahoo!? Yahoo! Small

Generating a chart/graph for comparison

Hi all, I need to capture data from oracle database and present it in form of a chart/ graph. Also, we need to compare the cureent week reports with last week, which can be done best through chart comparison. I checked out CPAN and found quite a few under category graph. Can someone please let m

Re: Execute include and return variables

> Hi all: Hi Tomas, > I cannot include a file so it can return all the > variables I assigned. > #FILE1.pl > $var1= "tom"; > #FILE2.pl > do FILE1.pl > #open $prog,'FILE1.pl' or die $!, > #use 'FILE1.pl' > #import 'FILE1.pl' In FIle2: do "FILE1.pl" (use double quotes) If you want to use "use "

Re: warn ?!

ne no. too) :-) Alok Bhatt --- Jayakumar Rajagopal <[EMAIL PROTECTED]> wrote: > Hi, > In my program , $sth->execute fails since > oracle tables already present. It is very natural. > But the waring message output line 37 is > different(just behaves as print) from same