Can i use list of array in filter data table Values? To check OR condition?

[MitheshBolla (Mithesh Reddy Bolla)]

@ppr

(from d in dtData.AsEnumerable()
Where arrValues.Any(x => x.Contains(d["USCIS Case Status"].ToString().Trim()))
Select r = d).CopyToDataTable();

still getting error

[ppr (Peter Preuss)]

better ro use the line breaks for easier reading as well

@ppr

keep in mind that in some scenarios also correct statements will not validate due some internal issues

As mentioned above and pre-announced

[MitheshBolla (Mithesh Reddy Bolla)]

means , we cant resolve in c#?

[MitheshBolla (Mithesh Reddy Bolla)]

kept in rows

[supermanPunch (Arpan)]

@MitheshBolla ,
I think the keywords need to be exact when specified in C#.

Could you try the below :

(from d in DT.AsEnumerable() 
where sheetNames.Any(x => x.Contains(d["USCIS Case Status"].ToString().Trim())) 
select d).CopyToDataTable();

[MitheshBolla (Mithesh Reddy Bolla)]

This worked bro ,For copying list of status from array to new sheet.
to delete the same list of arry in same Main sheet ie : DT?

(from d in DT.AsEnumerable()
where sheetNames.Any(x => x.Contains(d[“USCIS Case Status”].ToString().Trim()))
select d).CopyToDataTable();

Delete, delete is not working i checked.

[supermanPunch (Arpan)]

@MitheshBolla

Delete, delete is not working i checked.

@MitheshBolla , What was the method used for the Delete Operation ?

[MitheshBolla (Mithesh Reddy Bolla)]

The query which u have provided for me is to filter in dt and add to new sheet and also i need to delete those filtered rows in my main sheet.

will remove work?

(from d in DT.AsEnumerable()
where sheetNames.Any(x => x.Remove(d[“USCIS Case Status”].ToString().Trim()))
select d).CopyToDataTable();

[supermanPunch (Arpan)]

@MitheshBolla

also i need to delete those filtered rows in my main sheet.

@MitheshBolla ,

For Updating the Excel Sheet by Deleting the Filtered rows, we can first get the Filtered rows which does not match the condition. Meaning the reverse of the First Query. We can get the filtered rows using the below Query.

(from d in DT.AsEnumerable() 
where !sheetNames.Any(x =>x.Contains(d["USCIS Case Status"].ToString().Trim())) 
select d).CopyToDataTable();

It is the same Query, except we are using a ! operator (Not) which reverses the condition and it will able us to get the Non-Matching rows.

Now, To Update the Excel Sheet, we could first clear the entire rows in the sheet and then write the Filtered rows into it.
For clearing the entire sheet, we could use a Write Cell Activity as mentioned in the Post below.

Delete Excel data range without Excel Installed

@kasey.betts , Assuming that we have the Data already available in Datatable, which Represents the Data in the Excel, we can use it’s Column Count and Row Count information to Clear the Contents using Write Cell Activity. For Example : Let the Datatable be DT We get the Column Letter of the Excel by using the Column Count information as follows : columnLetter = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.Count+1) The above would help us get the Col…

Then use Write Range Activity to write the filtered Datatable to this Sheet Starting from A2.

[MitheshBolla (Mithesh Reddy Bolla)]

Thanks Bro ,

In this Post i had got solutions for the list below.

1. Passing arrylist to filter data table
2. filtering datatable with arrylist c# code
   3)deleting filtered arraylist in datatable with c# code.

Thank you all for your help.