i want to compare cell in same row of the excel file and if the value is matched then i have to remove the enitire column from excel and append the range
@akritiverma316 Welcome to our UiPath Community
- Excel Application Scope
- Use Read Range activity
- Loop through Each Row
- Inside the loop check column data If matches then Use Insert/Delete Rows activity else append range
can you share me work flow i will provide you an excel
For this you can simply use Filter Data Table activity with setting shown in below shot,
As you can see,
- Specify datatable variables for Input & Output datatables. (here, dt1 is output var of Read range.)
- Specify column name of having those values instead of Column1, select < (less than) operator & specify value as 30.
- select Remove radio button as you want to discard rows.
After this you can use write range with dt2 (Output var of Filter DataTable activity) to confirm output.
Welcome to UiPath Community !
Here is an activity called “Find”. It will return the cell info and row index.
To delete the column . you can use this activity.
To get the column name
use the assign activity .
strColumn = strCellInfo.Replace(intRowindex.tostring())
i used it but it ia not working as column1 i put the name of that column “Amount” still not working
I didn’t see your 2nd thread. Because you said that the value < 30 . my solution is exactly search value and remove the column . In that case you can follow @samir 's solution…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.