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

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

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

 



telemach
New User

Feb 18, 2008, 3:23 PM

Post #1 of 2 (242 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 :

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.

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 -


gurpreets
New User

Oct 15, 2009, 5:12 AM

Post #2 of 2 (209 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