Click here to get back home

Searching within XLS files - is it good approach ?
 Home | NewsGroups | Search | About
Login Password
Register Now!
 comp.lang.perl.misc    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Searching within XLS files - is it good approach ? Telemach 02-18-2008
Get Chitika Premium
Posted by Telemach on February 18, 2008, 3:13 pm
Please log in for more thread options
I'm newbie in Perl but don't give up so easily. My question is : Is it
possible to achieve my goals browsing just a xls file ? I know it's
good to convert to some better format but I would be happy if that
step is not necessary.

I have big Excel file which has over 20 worksheets.
What I need is to search for $value1 within the whole spreadsheet and
if found to search for $value2 within a worksheet where $value1 was
found. I know that cells have multi line input like :

ABCaaa
CDEbbb
EFGccc
etc.

so if $value2 = "CDE" I need Perl to get only CDEbbb and put under
$result1

next I want to read the col/row number of search result for $value2
and check the cell on two colums right from this one and copy the
content to $result2, if cell is blank I need to check
every single one above until cell with content is found

I'd appreciate any help about what module and commands shall be used
or where can I find an examples or a tutorial about searching withing
XLS files.

Kind regards,

- Telemach -

Posted by Joost Diepenmaat on February 18, 2008, 3:24 pm
Please log in for more thread options
> I'm newbie in Perl but don't give up so easily. My question is : Is it
> possible to achieve my goals browsing just a xls file ? I know it's
> good to convert to some better format but I would be happy if that
> step is not necessary.

I've only used SpreadSheet::WriteExcel, which as the name implies,
doesn't read excel files, but the documentation for that module points
to a lot modules that do. See:

<http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.20/lib/
Spreadsheet/WriteExcel.pm#READING_EXCEL_FILES>

As far as I can tell, most of those will only work on Windows.

Even more can probably be found if you search for "excel" on
<http://search.cpan.org/>


--
Joost Diepenmaat | blog: http://joost.zeekat.nl/ | work: http://zeekat.nl/

Posted by Telemach on February 18, 2008, 3:42 pm
Please log in for more thread options
> As far as I can tell, most of those will only work on Windows.

I need to get this working under linux


> Even more can probably be found if you search for "excel" on
> <http://search.cpan.org/>

I found some but still can't get a decent documentation how to search
and not only read.

- Telemach -

Similar ThreadsPosted
How good is PERL at searching ASCII files? December 7, 2006, 10:45 am
Scalable method for searching in relatively big files June 28, 2006, 4:26 am
Searching large files with a regex and a list May 30, 2006, 11:00 pm
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you are, April 21, 2005, 1:25 pm
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you are, April 22, 2005, 3:33 pm
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you are, April 24, 2005, 6:50 pm
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you are, May 1, 2005, 11:27 am
an approach August 16, 2004, 1:03 pm
Problem using SWIG approach April 14, 2006, 10:45 am
Good documentation or good source examples for Image::Magick or converter from commandline to perl April 1, 2008, 5:23 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap