Re: parsing a large excel file

2008-07-22 Thread Dr.Ruud
"ANJAN PURKAYASTHA" schreef: > i have installed Spreadshee::ParseExcel to parse some large excel data > files. > Here is the problem I'm facing. I need to parse data from columns M > to P and rows 10 to 43000. Now I know that there is a PrintArea > method that can print an area of a worksheet spec

RE: parsing a large excel file

2008-07-22 Thread Stewart Anderson
> -Original Message- > From: ANJAN PURKAYASTHA [mailto:[EMAIL PROTECTED] > Sent: 22 July 2008 02:41 > To: beginners@perl.org > Subject: parsing a large excel file > > to all, > i have installed Spreadshee::ParseExcel to parse some large excel data > files. > Here is the problem I'm facing

RE: parsing a large excel file

2008-07-22 Thread Stewart Anderson
> -Original Message- > From: Stewart Anderson > Sent: 22 July 2008 09:34 > To: ANJAN PURKAYASTHA; beginners@perl.org > Cc: Stewart Anderson > Subject: RE: parsing a large excel file > > > > -Original Message- > > From: ANJAN PURKAYASTHA [mailto:[EMAIL PROTECTED] > > Sent: 22 July

fetching to docs using wget

2008-07-22 Thread a b
Hi, I am trying to fetch various docs from server using wget. Below is the code Files are downloading but of 0 size :( Am i missing any thing [EMAIL PROTECTED]:~/adave> cat fetch.pl open(S,"<./source.txt") || die "Failed to open file 'source.txt' $!"; while() { if (/http/) {

Re: fetching to docs using wget

2008-07-22 Thread Rob Dixon
a b wrote: > > I am trying to fetch various docs from server using wget. Below is the code > Files are downloading but of 0 size :( > > Am i missing any thing > > [EMAIL PROTECTED]:~/adave> cat fetch.pl > open(S,"<./source.txt") || die "Failed to open file 'source.txt' $!"; > while() > { > > i

Re: parsing a large excel file

2008-07-22 Thread ANJAN PURKAYASTHA
thanks for your helpful responses. Dr Ruud my aim was to parse the text area M10..P43000 and then print it using PrintArea. Maybe I have misunderstood the function of PrintArea. Stewart, many thanks for the suggestion. I will indeed try it out and see what happens. Anjan On Tue, Jul 22, 2008 at

Re: DBI error

2008-07-22 Thread Rob Dixon
Panda-X wrote: > > I've got this error, anything I can do ? > > "Can't locate auto/DBI/data_source.al in @INC " > > Code : > >use DBI; >my @dataSource = DBI -> data_source ( "mysql" ) ; The method call is DBI->data_sources('mysql'); > and if I change the as this : > > us

Re: parsing a large excel file

2008-07-22 Thread Rob Dixon
ANJAN PURKAYASTHA wrote: > > i have installed Spreadshee::ParseExcel to parse some large excel data > files. > > Here is the problem I'm facing. I need to parse data from columns M to P and > rows 10 to 43000. Now I know that there is a PrintArea method that can print > an area of a worksheet spec

Having trouble with cpan

2008-07-22 Thread Barry Benowitz
Hi All, I am having trouble with CPAN to update my perl packages. Here is the error: [EMAIL PROTECTED] ~]# cpan cpan shell -- CPAN exploration and modules installation (v1.7602) ReadLine support enabled cpan> install String::scanf CPAN: Storable loaded ok Going to read /home/ba

Re: Howto Pull files from two diff machines

2008-07-22 Thread Andy
Hiya Guys You guys have been previously helping me with a script. "Debug Please" Was the title. It's working as far as we can tell. But I need to be able to ftp to two machines and pull down xferlog Therefore each xferlog would be downloaded as xferlog.host.month.log Then either joined as on

how to reinvent "tar xvfz" with perl?

2008-07-22 Thread Siegfried Heintze (Aditi)
I need to automate some stuff and decided to use perl. I have cygwin perl and activestate perl. Below is my attempt. It does not work because I don't have perlIO::gzip installed. When I tried /bin/Perl -MCPAN -e 'install PerlIO::gzip' The tests fail and it won't install. When I try activesta

Re: how to reinvent "tar xvfz" with perl?

2008-07-22 Thread Rob Dixon
Siegfried Heintze (Aditi) wrote: > > I need to automate some stuff and decided to use perl. > > I have cygwin perl and activestate perl. > > Below is my attempt. It does not work because I don't have perlIO::gzip > installed. > > When I tried > > /bin/Perl -MCPAN -e 'install PerlIO::gzip' >

Re: DBI error

2008-07-22 Thread Panda-X
Ah! Yes!! Thank you very much!! Problem fixed now =) 2008/7/22 Rob Dixon <[EMAIL PROTECTED]>: > > Panda-X wrote: > > > > I've got this error, anything I can do ? > > > > "Can't locate auto/DBI/data_source.al in @INC " > > > > Code : > > > >use DBI; > >my @dataSource = DBI -> data_

Re: Having trouble with cpan

2008-07-22 Thread Tom Phoenix
On Tue, Jul 22, 2008 at 10:53 AM, Barry Benowitz <[EMAIL PROTECTED]> wrote: > cpan> install String::scanf Shouldn't that be String::Scanf? Capitalization can be important; if not here, certainly when you use the module. > Can't call method "value" on an undefined value at > /usr/lib/perl5/vendor