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
Hi @akritiverma316,
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.
Hi @akritiverma316,
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.
Note :
To get the column name
use the assign activity .
strColumn = strCellInfo.Replace(intRowindex.tostring())
Thank you
Balamurugan.S
i used it but it ia not working as column1 i put the name of that column “Amount” still not working
Hi ,
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…
Regards
Balamurugan.S
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.