Want to delete data from excel

Help Robot
,
1

Hi team,
I have Two sheet name as A and B
I have done Reconciliation from Both excel sheet and make one Recon excel sheet
Now i want to remove all the line items that have already been reconciled in Recon excel from A sheet

2

Could you please elaborate?
Do you want to append all sheets data in one and delete rest?

3

Now I want to Delete data from A Excel
I have to Compare Recon sheet and A excel sheet and delete data which is same in both sheet Deletion will work on A excel sheet

4

Any Answer?

5

Hi @Kuldeep_Pandey,

Read data from a sheet and delete from another sheet based on some conditions you can actually follow below steps:

  1. Use read range to read both excel sheet e.g. DT1 and DT2.
  2. Loop on DT1 to check DT2 has the same row or not
  3. If condition DT2.AsEnumerable.Any(Function(x) x(“columnInDT2”).ToString.Equals(CurrentRow(“columnInDT1”)) And …)
    i) Do the steps to delete row from sheet A using Delete Range
    Else:
    Do the steps if row is not present in Sheet B.
6

please provide xml file

7

Hi please find the sample data with 2 sheets and main.xaml.
Feel free to ask if not able to understand the code.
Data.xlsx (9.1 KB)
Main.xaml (16.7 KB)