Copy all excel values of duplicated ID No. to anothre excel file

Help StudioX
, , , ,
1

How to copy the data of duplicated idno. from excel file to new excel file?
Because i want to copy the values of the certain id number to new excel but im stuck in copying just 1 row instead of multiple rows of the id no.

2

Hi @flashdrive07,

Welcome to UiPath Forum

You can use the “Read Range” activity to read the data from the excel file. Then use a “For Each Row” activity to iterate through the rows of the excel file. Inside the “For Each Row” activity, use an “If” condition to check if the ID number of the current row matches the ID number you want to copy. If it does, then use a “Write Range” activity to write the data from the row to a new Excel file.

Thanks,

3

Hi @flashdrive07

Welcome to our community

give a try with the following

(From d In dt.AsEnumerable
Where d("yourColumnName").ToString().Trim().ToUpper().Contains("yourValue")
Select r = d).CopyToDataTable

Regards