CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: Beginner:
How to search and read XLS files ?


New User

Feb 18, 2008, 3:23 PM

Post #1 of 2 (241 views)
How to search and read XLS files ? Can't Post

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 :


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.

I know that Spreadsheet::ParseExcel might be good but still haven't found a good examples how to search within all of worksheets or in the particular one ? Shall I write a foreach loop that will check every single cell that exists ?

Kind regards,

- Telemach -

New User

Oct 15, 2009, 5:12 AM

Post #2 of 2 (208 views)
Re: [telemach] How to search and read XLS files ? [In reply to] Can't Post

A search script will really help. Anyone who can provide us one here !!


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives