Jump to content
Jess

Applying filter to an excel sheet from an array

Recommended Posts

Jess

Hi,

I am trying to apply filter to an excel sheet from another excel sheet. I am storing the set of filters to be applied in an array and apply the filter to the excel sheet. The set of filters contains alphanumeric numbers and a number. When I run the script it is working fine and applying filters. The problem in applying filters is that it  does not take into consideration the number in array, but only the other texts in array.

Can someone guide me as to why is this happening.

 

Thank You.

Share this post


Link to post
Share on other sites
water

Can you post a reproducer script/Excel file so we can play with it?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
Jess

Hi @water.

I played around after posting this query and I was able to make up. The issue was that I was storing the number as text. In the second sheet where I need to apply filter , it was other way around.

Now it is working fine.

Thanks

Share this post


Link to post
Share on other sites
water

:)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×