Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^4: Search Entire Excel Workbook For Text

by ImJustAFriend (Sexton)
on Oct 17, 2012 at 14:48 UTC ( #999553=note: print w/ replies, xml ) Need Help??


in reply to Re^3: Search Entire Excel Workbook For Text
in thread (( Resolved )) Search Entire Excel Workbook For Text

Thank you for your post and info, dasgar. My sincere apologies for the misleading post, to you and to sundialsvc4.

I need help with Excel, not the XML. I am looking for a way to search for a particular string within an Excel spreadsheet (say "ce0_ipaddress") in a workbook, hopefully with results like "found ce0_ipaddress in worksheet 'Server1 IP Info' in column 0 of row 35". Is that even possible?

In answer to your questions:
OS: Windows XP
Excel: I have Office 2007 installed and ready
File format: .xls file, not .xlsx

Thanks again!!

ImJustAFriend


Comment on Re^4: Search Entire Excel Workbook For Text
Re^5: Search Entire Excel Workbook For Text
by marto (Chancellor) on Oct 17, 2012 at 14:55 UTC

    You could use the module Spreadsheet::ParseExcel to read the values of cells, you then need to do some coding to compare these values and create the output you required.

      Thanks Marto. I am already using Spreadsheet::ParseExcel to read the cell values. My question is the "do some coding" piece of your response...

      Thanks again!!

      ImJustAFriend

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://999553]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (10)
As of 2014-09-03 06:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (35 votes), past polls