macran Posted March 27, 2015 Share Posted March 27, 2015 $ar_array=_ExcelReadSheetToArray($arexcel,2) ;----from 2nd row $weekly_array=_ExcelReadSheetToArray($weeklyexcel,2,5) ;----from 2nd row and 5th col how to get the same effect by use _Excel_RangeRead? thanks! Link to comment Share on other sites More sharing options...
l3ill Posted March 27, 2015 Share Posted March 27, 2015 Have a look here The second example shows how to set the parameters to extract to an array. My Contributions... SnippetBrowser NewSciTE PathFinder Text File Manipulation FTP Connection Tester / INI File - Read, Write, Save & Load Example Link to comment Share on other sites More sharing options...
water Posted March 27, 2015 Share Posted March 27, 2015 Or you could read the whole worksheet and simply ignore the unneeded cells. Another approach: Example 3 shows how to use the UsedRange object. 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