100Conrad

_Excel_RangeRead

4 posts in this topic

I´m trying to use the new function _Excel_RangeRead in the updated UDF Excel.au3. It looks better than the old one but I can´t make it work.

#include <Excel.au3>

$oExcel = ObjGet("", "Excel.Application") ; Get an existing Excel Object

$aArray = _Excel_RangeRead ( $oExcel,1 ,"C15:E20",1)

MsgBox ( 1, "Titel", $aArray[1][1]  )

 

I get the following error:

"M:PonnyAutoitScriptsTest2.au3" (14) : ==> Subscript used on non-accessible variable.:
MsgBox ( 1, "Titel", $aArray[1][1]  )
MsgBox ( 1, "Titel", $aArray^ ERROR

Can someone please help me out?

Share this post


Link to post
Share on other sites



Welcome to AutoIt and the forum!

Please have a look at the example for _Excel_RangeRead in the help file. It explains how the function needs to be used.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

I checked the help file before writing in this forum and also tested the exemples. Worked fine but my first try didn´t.

I´m just trying to read a range filled with numbers in a worksheet and test if I suceeded with the messagebox

Share this post


Link to post
Share on other sites

The new Excel UDF doesn't work the same way as the old did.

You need to call

  • _Excel_Open: Start Excel or connect to an already running instance
  • _Excel_BookOpen: To open an existing Excel file or _Excel_BookAttach to connect to an already opened Workbook
  • _Excel_RangeRead in your case.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now