topic RE: Some Items in excel not filtered in University Forum

Some Items in excel not filtered

SachinanShahi — Thu, 23 Jan 2020 06:40:00 GMT

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
------------------------------

RE: Some Items in excel not filtered

vivek.kumar.goel — Thu, 23 Jan 2020 06:44:00 GMT

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

RE: Some Items in excel not filtered

SachinanShahi — Thu, 23 Jan 2020 06:56:00 GMT

Please find the attached files

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

RE: Some Items in excel not filtered

vivek.kumar.goel — Thu, 23 Jan 2020 07:05:00 GMT

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

RE: Some Items in excel not filtered

SachinanShahi — Thu, 23 Jan 2020 07:12:00 GMT

should i check this by going into ms exel vbo?

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

RE: Some Items in excel not filtered

SachinanShahi — Thu, 23 Jan 2020 08:16:00 GMT

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
------------------------------

RE: Some Items in excel not filtered

SachinanShahi — Thu, 23 Jan 2020 09:06:00 GMT

please help me in understanding the code

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