I have "source.xlsx" and "destination.xlsx". Source.xlsx has a list of serialNumbers, one per row (in column "SerialN").
Destination.xlsx has the same serialNumbers, one per row (in column "SerialN").
I wish to go trough each of the serialNumber in "source.xml and find the equivalent in "destination.xlsx" (in column "SerialN").
If number is a match then, in "destination.xlsx" column labelled "Pass?" enter "passed".
I am new to Spreadsheet Light, and classify myself ha a beginner in C#. I have seen many examples, on the developer site and this site, but got confused about it.
Can you please help?
Regards Francesco C
NOTE: I have changed xls to xlsx. made an error.