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

You're mostly correct. Most of your post was talking about XML, which I think could confuse folks about what you're needing help with: XML or Excel.

What OS are you on? If you're on Windows, do you have Excel installed and available for use? Which Excel version is the file that you're using?

  • Comment on Re^3: Search Entire Excel Workbook For Text

Replies are listed 'Best First'.
Re^4: Search Entire Excel Workbook For Text
by ImJustAFriend (Scribe) on Oct 17, 2012 at 14:48 UTC

    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

      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