I wish to delete a row in excel that contains a cell containing text xyz. The excel is the result of appending different excel documents therefore the location of this cell is variable. How can I teach my robot to delete the row that contains a cell containing a specific value? I have tried different methods but I am really struggling to find the correct action.
you can do this
-
read excel into datatable variable (read range)
-
use filter datatable activity , select remove
and specify the column name e.g. “Header1”, -
write the new datatable
are you using excel aplication scope ??
if your are using inside excel application scope then you can use BALAREVA activities(Package available n manage packages)
Or else you can use link query
dt1 = dt1.AsEnumerable.Where(Function(row) Not row(“column1”).ToString.Contains(“keyword”) ).CopyToDataTable
write the dt1 to a new sheet you will get that rows without that keyword
Thanks for replying Jack. I don’t know what version of UiPath you are using. I cannot use the read range activity. I am using the studiox version.
Hi Sree, thanks for replying. I am not using excel application scope. Would I be able to what you just said on Uipath studiox?
yes you try the link query
Jack, For some reason I do not have the activities “read range” and “filter data table”. Also StudioX canno open the file you attached. Do you know why this happens?
i am using studioX too !
can you send me your whole project folder as a .zip