Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re^2: Search Entire Excel Workbook For Text

by ImJustAFriend (Sexton)
on Oct 16, 2012 at 15:29 UTC ( #999353=note: print w/ replies, xml ) Need Help??


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

So, I am not familiar with XPath. I have been looking at this since I read your post, and it seems XPath is used to read XML, not Excel. Am I seeing this correctly?

Thank you!!

ImJustAFriend


Comment on Re^2: Search Entire Excel Workbook For Text
Re^3: Search Entire Excel Workbook For Text
by dasgar (Deacon) on Oct 16, 2012 at 17:18 UTC

    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?

    • As for Excel file type, there's the older .xls version and the newer .xlsx type. Very different structures.
    • From non-Windows OSes and Windows without Excel, you'll probably be interested in Spreadsheet::ParseExcel for the older .xls file type and Spreadsheet::XLSX for the newer .xls.
    • From a Windows system with Excel, I personally would use Win32::OLE to control Excel to access the Excel file.
    • Also, with the .xlsx file type, there's another route to go. I believe that's just a compressed XML file. That means that you can uncompress it and then do XML parsing. If you go that route, then sundialsvc4's response about using XPath type modules for XML parsing now becomes very applicable.

      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.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (6)
As of 2014-08-22 00:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (144 votes), past polls