View Full Version : compare two rows form excel files using array and objects

09-04-2008, 03:46 PM
hi there

is it possible to compare two rows of two diffrent excel files by storing the values in the array objects .


09-08-2008, 04:23 PM
hi coders there any ideas regarding this one

Philip M
09-08-2008, 05:24 PM

If you mean how do you compare the two rows from the Excel files after you have captured them,
something like this:-

<script type = "text/javascript">
var x = "The quick brown fox jumps over the lazy dog";
var xArray = x.split(" ");
var y = "The quick brown cat jumps over the lazy dog";
var yArray = y.split(" ");

for (var i =0; i<=x.length; i++) {
if (xArray[i] != yArray[i]) {
alert ("Array element " + i + " does not match");

Quizmaster: The Cairngorm Mountains are home to Britain's last free-ranging herds of which animals, popularly associated with Christmas?
Contestant: Turkeys.

10-01-2008, 01:32 PM
compare cells of the row such as 1a with 1a and b with 1b etc and if any of the cell is different then paste the entire row in the third sheet with suffix changed.