in reply to Comparing two Excel spread sheets

I'll give you a Perl answer though :).

Use a combination of the modules Spreadsheet::ParseExcel and Data::Dumper. Parse both spreadsheets, serialise the results with Data::Dumper and diff the results (though you could use Array::Compare as an alternative).

--

Oh Lord, won’t you burn me a Knoppix CD ?
My friends all rate Windows, I must disagree.
Your powers of persuasion will set them all free,
So oh Lord, won’t you burn me a Knoppix CD ?
(Missquoting Janis Joplin)

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.