Feb 18, 2008, 3:23 PM
Post #1 of 2
I'm newbie in Perl but don't give up so easily.
How to search and read XLS files ?
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 ?
- Telemach -