Hello everyone, how could I delete the rows of a datatable that from column K to S have no data or have 0
That is, for this example I need to delete the rows from 2 to 7
Have you tried filter datatable activity for this…
https://docs.uipath.com/activities/docs/filter-data-table
Thanks
just use the below activity in excel scope
list(datarow)=InputDataTable.AsEnumerable.Where(Function(r) r(“column_name”) IsNot Nothing AndAlso Microsoft.VisualBasic.Information.IsNumeric(r(“column_name”).toString) )).toList
then write it using invoke method
please share excel …
Thank you very much, I attach the excel file (this is summarized since the file I work with has 500 records)
PruebaNal.xlsx (13.9 KB)
how many records you want to del i mean range
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.