linbin Posted December 9, 2014 Share Posted December 9, 2014 Excel File: A B 1 20 20 2 40 40 3 50 50 4 60 60 5 20 20 Code: Local $aShow[] = ["20", "40", "60"] _Excel_FilterSet($oWorkbook, Default, Default, 2, $aShow, $xlFilterValues) Excel File after filter: A B 1 20 20 2 40 40 5 20 20 Why 60 is not displayed? Link to comment Share on other sites More sharing options...
water Posted December 9, 2014 Share Posted December 9, 2014 Shouldn't parameter 4 be set to 1? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Jfish Posted December 9, 2014 Share Posted December 9, 2014 (edited) Could you >merge these threads? These two look like the same issue but the newer one has more information. I replicated that file and get the following after it runs ... 40 40 60 60 20 20 This is the code I used: #include <Excel.au3> Local $oAppl = _Excel_Open() If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_FilterSet Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended) Local $oWorkbook = _Excel_BookOpen($oAppl, @ScriptDir &"\excelsort.xlsx", True) Local $aShow[] = ["20", "40", "60"] _Excel_FilterSet($oWorkbook, Default, Default, 2, $aShow, $xlFilterValues) while 1 WEnd Edited December 9, 2014 by Jfish Build your own poker game with AutoIt: pokerlogic.au3 | Learn To Program Using FREE Tools with AutoIt Link to comment Share on other sites More sharing options...
linbin Posted December 10, 2014 Author Share Posted December 10, 2014 Could you >merge these threads? These two look like the same issue but the newer one has more information. I replicated that file and get the following after it runs ... 40 40 60 60 20 20 This is the code I used: #include <Excel.au3> Local $oAppl = _Excel_Open() If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_FilterSet Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended) Local $oWorkbook = _Excel_BookOpen($oAppl, @ScriptDir &"\excelsort.xlsx", True) Local $aShow[] = ["20", "40", "60"] _Excel_FilterSet($oWorkbook, Default, Default, 2, $aShow, $xlFilterValues) while 1 WEnd It works on Excel 2010 . I think only two criterias is allowed in Excel 2003. Link to comment Share on other sites More sharing options...
water Posted December 10, 2014 Share Posted December 10, 2014 Where did you find this information? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now