HighlanderSword Posted February 16, 2017 Share Posted February 16, 2017 Hello, Is it a known Issue when using Range_Read from the Excel UDF , and the range being read has any #N/A Values for a fomula it will not read in the values and aborts with error codes. I know I can change the Formula to not display the NA Value, however I then have to change all of the other formulas in the workbook that are using the #N/A and doing something to the cell. Link to comment Share on other sites More sharing options...
water Posted February 16, 2017 Share Posted February 16, 2017 Not known. Will check. Can you please post the exact statement you run? 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...
HighlanderSword Posted February 16, 2017 Author Share Posted February 16, 2017 Local $aResult = _Excel_RangeRead($oWorkbook, 2, "A1:B13",1) Link to comment Share on other sites More sharing options...
water Posted February 16, 2017 Share Posted February 16, 2017 Try Global $aResult = _Excel_RangeRead($oWorkbook, 2, "A1:B13", 1, True) The Excel transpose method seems to have a problem mit #NA. So the above call uses the internal function. 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...
HighlanderSword Posted February 16, 2017 Author Share Posted February 16, 2017 That brings all of the #N/A is blank cells , the #N/A is not there in the new array Link to comment Share on other sites More sharing options...
water Posted February 17, 2017 Share Posted February 17, 2017 #N/A is returned as NULL. You could use the following code to check for NULL and - if needed - set the array's cell to accordingly. MsgBox(0, "Null?", IsKeyword($aResult[0][0]) = $KEYWORD_NULL) 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...
HighlanderSword Posted February 20, 2017 Author Share Posted February 20, 2017 ok will give that a try and also check what is does with Excel cells that have no data as well. 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