How to find the data in few columns like Column A, B and C in Excel using modern activities in Uipath

Help Activities
1

Hi Team,

I have one excel with merge cells also there in my excel
Here I want to find the data in Column A,B and C columns only .
Because the data is also contains in different columns.
In A,B and C columns only I have to find the data using modern activities in UiPath

I was used find or replace modern activitie to find the data in Excel
But here the issue is in the where to serch filed i was passed to entire sheet
But I took K column data I need to took the data in A or B or C columns only because those 3 columns data is correct.

Here how to pass the columns data instead of entire sheet in find or replace activity (where to search filed).

Regards
Baby

2

@Baby123

You can pass Excel.Sheet("SheetName").Range("A:C")

Hope this helps

Cheers

3

@Baby123

  1. Read Range (Output: dtInput) - Read your Excel file into a DataTable.

  2. Filter DataTable (Output: dtFiltered)

    • Use Filter DataTable to filter dtInput based on the conditions for columns A, B, and C.

  3. For Each Row (Input: dtFiltered)

    • Loop through the filtered DataTable.

    3.1 Assign - Assign values from the current row to variables.

    3.2 Find or Replace - Use the “Find or Replace” activity with the variables from step 3.1.