How to compare 2 excel sheet column values RRS feed

  • Question

  • User-1764659617 posted


    i have  2 excel sheets(i am using excel 2007)

    excel sheet1  with column







     then i have  one more  excel sheet 2

    excel sheet2  with column




    here i need  to compare these 2 excel sheet and then return the  names  which are missing in  excel sheet2  add  those  names missing in a new excel sheet

    hope my question is clear. anyhelp would be great


    Tuesday, July 13, 2010 5:37 AM


  • User2089561920 posted

    you can use vsto to open the excel sheet, compare the data and write it back. however vsto is not really recommended for asp.net websites due to the different nature. iis is multi-threaded, excel is not

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, July 13, 2010 10:49 AM