jimmyjmmy Posted July 28, 2018 Posted July 28, 2018 Hi, Below it is showing the whole excel sheet. What I want is to display only the active cells. So what perimeters I must put.Thanks _ExcelRangeRead ($oWorkbook,default,default,1,default)
jimmyjmmy Posted July 28, 2018 Author Posted July 28, 2018 OK thanks. Anyway I just found out that by default, it displayed only the active cells.
water Posted July 28, 2018 Posted July 28, 2018 (edited) You mean "used cells"? Active cells are those selected by the user. Used cells are those which have or had content assigned to them. For details please have a look a the Excel pages in the wiki:https://www.autoitscript.com/wiki/Excel_UDF#Range Edited July 28, 2018 by water My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
JoHanatCent Posted July 28, 2018 Posted July 28, 2018 Local $sResult = _Excel_RangeRead($oWorkbook, Default, $oWorkbook.Application.ActiveCell.Address)
jimmyjmmy Posted July 28, 2018 Author Posted July 28, 2018 Hi, Thanks to JoHanatCent and Water. Yes ,I mean used cells. Anyway this matter is resolved.
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