locked
How to compare 2 excel sheet column values RRS feed

  • Question

  • User-1764659617 posted

    hi,

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

    excel sheet1  with column

     name 

    kumar

    kiran

     manju

     anu

     

     then i have  one more  excel sheet 2

    excel sheet2  with column

     name 

    kumar

     anu

    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

     thanks

    Tuesday, July 13, 2010 5:37 AM

Answers

  • 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