I am trying to compare to excel sheets. Let me explain it with brief scenario:
Assume I have 2 excel sheets A and B.
I want to compare first column of both the sheets. I stored both the excel sheet into datatables dt_A and dt_B. Now I am having a foreach loop for dt_A and under body I have LookUpDatatable for dt_B. After wards I am comparing if the cell value is null, I am using a Add row item to add the row in dt_A to another datatable let’s say dt_C.
But I am getting an error Object reference not set to instance of object.
Can you please help me with this.
Thanks in advance.