Some Items in excel not filtered

[SachinanShahi]

Hi,
i am trying to filter one excel file but due to size of that item it's not getting filtered. Please help me to fix this code.

------------------------------
Sachinan Shahi
------------------------------

[vivek.kumar.goel]

Can you provide more information about the issue?
1- What's the excel extension?
2 - Are you trying to filter after reading into collection? or before reading into collection?
3- What's the exact error?
4- How to reproduce?

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
"If you like this post, please press the "Recommend" Button.
------------------------------

[SachinanShahi]

Please find the attached files

------------------------------
Sachinan Shahi
------------------------------

[vivek.kumar.goel]

The Action- "Set Autofilter by Column (Values)" Doesn't seem to be an out of box action. Can you check if it's custom coded?.

If yes, Can you send the code for checking?

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
"If you like this post, please press the "Recommend" Button.
------------------------------

[SachinanShahi]

should i check this by going into ms exel vbo?

------------------------------
Sachinan Shahi
------------------------------

[SachinanShahi]

Dim wb, ws, excel,sheet As Object
Dim xlFilterValues as Integer = 7
Try

'Get WorkBook and WorkSheet wb = GetWorkbook(Handle, Workbook)
wb.Activate()
If Worksheet <> "" Then  ws = GetWorksheet(Handle, Workbook, Worksheet) ws.Activate() End If
excel = wb.Application sheet = excel.ActiveSheet sheet.Range(SelectedRange).AutoFilter(Field:=ColumnNumber, Criteria1:= ValueList.Split(","), Operator:=xlFilterValues)
Success = TrueCatch e As Exception Success = False Message = e.MessageFinally wb = Nothing ws = Nothing excel = Nothing sheet = NothingEnd Try

------------------------------
Sachinan Shahi
------------------------------

[SachinanShahi]

please help me in understanding the code

------------------------------
Sachinan Shahi
------------------------------