Cooler Posted May 22, 2019 Share Posted May 22, 2019 In this following script, the count value is updating for the whole sheet used rows. But I need used range of a specified column. Here I attached excel sheet. If it search in A column it should give $count =8. If it search in B column it should give $count =5. If it search in C column it should give $count =3. If it search in A column it should give $count =7. What I missed here friends..! #include <Misc.au3> #include <Excel.au3> #include <GDIPlus.au3> #include <WinAPI.au3> $oBook = _Excel_BookAttach ( @DesktopDir & "\test.xlsx") $oBook.Sheets(1).Select $Count = $oBook.Sheets(1).UsedRange.Rows.Count Sleep( 1000) MsgBox ($MB_SYSTEMMODAL,"$Count",$Count) test.xlsx Link to comment Share on other sites More sharing options...
water Posted May 22, 2019 Share Posted May 22, 2019 Please check the wiki: https://www.autoitscript.com/wiki/Excel_Range#Used_Range 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...
Cooler Posted May 24, 2019 Author Share Posted May 24, 2019 Got it😍. Thanks for your help! Link to comment Share on other sites More sharing options...
water Posted May 24, 2019 Share Posted May 24, 2019 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