Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Some Items in excel not filtered

SachinanShahi
Level 3

‎23-01-20 06:40 AM

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
------------------------------
0 Likes
6 REPLIES 6

VivekGoel
Level 10

‎23-01-20 06:44 AM

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.
------------------------------
0 Likes

SachinanShahi
Level 3
In response to VivekGoel

‎23-01-20 06:56 AM

Please find the attached files
33942.png
33943.png
33944.png
33946.png


------------------------------
Sachinan Shahi
------------------------------
0 Likes

VivekGoel
Level 10
In response to SachinanShahi

‎23-01-20 07:05 AM

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.
------------------------------
0 Likes

SachinanShahi
Level 3
In response to VivekGoel

‎23-01-20 07:12 AM

should i check this by going into ms exel vbo?

------------------------------
Sachinan Shahi
------------------------------
0 Likes

SachinanShahi
Level 3
In response to VivekGoel

‎23-01-20 08:16 AM

Dim wb, ws, excel,sheet As Object
Dim xlFilterValues as Integer = 7
Try
33959.png
'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
------------------------------
0 Likes

SachinanShahi
Level 3
In response to SachinanShahi

‎23-01-20 09:06 AM

please help me in understanding the code

------------------------------
Sachinan Shahi
------------------------------
0 Likes