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