Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Sep 2008
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    compare two rows form excel files using array and objects

    hi there

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

    thanks

  • #2
    New to the CF scene
    Join Date
    Sep 2008
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hi coders there any ideas regarding this one

  • #3
    Supreme Master coder! Philip M's Avatar
    Join Date
    Jun 2002
    Location
    London, England
    Posts
    17,731
    Thanks
    202
    Thanked 2,508 Times in 2,486 Posts
    Ajax.

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

    Code:
    <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");
    }
    }
    </script>

    Quizmaster: The Cairngorm Mountains are home to Britain's last free-ranging herds of which animals, popularly associated with Christmas?
    Contestant: Turkeys.
    Last edited by Philip M; 09-08-2008 at 04:34 PM.

  • #4
    New to the CF scene
    Join Date
    Sep 2008
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

    thanks


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •