Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: compare two Excel spreadsheets

by davidrw (Prior)
on Jul 14, 2005 at 03:26 UTC ( [id://474729]=note: print w/replies, xml ) Need Help??


in reply to compare two Excel spreadsheets

does it have to be in perl? you could use excel's vlookup function (note you'll need to sort the general data, and pay attention to the "fuzzy match" flag)

anyways, to do it in perl, first check out the Index of Spreadsheet FAQs node. then the general approach will be to read the general data in and probably create a hash with the strings as keys. Then you can read the search strings column, and check if each row exists in the general data hash.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (4)
As of 2024-04-20 00:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found