excel

2004-05-21 Thread DiGregorio, Dave
Does anyone know, what is the best way to retrieve text data from an Excel Spreadsheet? I have tried the code below and it returns errors. I can not even get the name of the file to print! #! usr/bin/perl -w use strict ; use Spreadsheet::ParseExcel ; my $oExcel = new Spreadsheet::

Re: foreach problem

2004-05-21 Thread Ron B
Thanks. I modified the while loop to fit my purpose. Sami Panula (aka Ron B) Bob Showalter wrote: Ron B wrote: My problem is how to print the next line after the line that includes BLAH. So I want to print lines including BLAH keyword and when BLAH is found the next line after it. #!/usr/bin/perl

RE: foreach problem

2004-05-21 Thread Bob Showalter
Ron B wrote: > My problem is how to print the next line after the line that > includes BLAH. So I want to print lines including BLAH keyword and > when BLAH is found the next line after it. > > #!/usr/bin/perl > # print lines wich include BLAH keyword > print "Content-type: text/html\n\n"; > prin

foreach problem

2004-05-21 Thread Ron B
I'm working with very simple viewer code and here's a working snippet of it. My problem is how to print the next line after the line that includes BLAH. So I want to print lines including BLAH keyword and when BLAH is found the next line after it. The next line carries additional info for the k