Error Excel RangeRead (Solved)

[Danyfirex]

Hello. I was trying to automate some excel task. But I can figure me out why I cant read this excel sheet.

#include <Array.au3>
#include <Excel.au3>
#include <MsgBoxConstants.au3>

; Create application object and open an example workbook
Local $oExcel = _Excel_Open()
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
Local $oWorkbook = _Excel_BookOpen($oExcel, "Test.xlsx")
If @error Then
    MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example", "Error opening workbook '" & @ScriptDir & "\Extras\_Excel1.xls'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
    _Excel_Close($oExcel)
    Exit
EndIf

; *****************************************************************************
; Read the formulas of a cell range on sheet 2 of the specified workbook
; *****************************************************************************

Local $aResult = _Excel_RangeRead($oWorkbook)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 2", "Error reading from workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 2", "Data successfully read." & @CRLF & "Please click 'OK' to display the formulas of cells A1:C1 of sheet 2.")
_ArrayDisplay($aResult, "Excel UDF: _Excel_RangeRead Example 2 - Cells A1:C1 of sheet 2")

I got Error.

Excel file. Removed 

Saludos

 

Edited October 23, 2015 by Danyfirex
Solved

[JLogan3o13]

I got Error.

Can you share exactly what the error is? Might help us a bit. The code runs fine for me, as long as I change the path:

#include <Array.au3>
#include <Excel.au3>
#include <MsgBoxConstants.au3>


Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\Test.xlsx", Default, Default, 2)
Local $aResult = _Excel_RangeRead($oWorkbook)
    _ArrayDisplay($aResult, "Excel UDF: _Excel_RangeRead Example 2 - Cells A1:C1 of sheet 2")

Edit: I should specify, I put in 2 because you stated you're trying to read the formulas of a cell range. Also, your text in the _Arraydisplay does not match your call to _Excel_RangeRead, you're reading in the whole sheet, not A1:C1. Wasn't sure which you were truly after.

Edited October 23, 2015 by JLogan3o13

[JohnOne]

Yes, I had problem like that, intermittent, needed full path.

[Danyfirex]

I feel like idiot. work correctly with _Excel_RangeRead($oWorkbook, Default, Default,2)

 

Thank you guys.

 

Saludos

 

 

[kcvinu]

I am using "$WorkSheet.Cells(Row, Column).Value" for getting specific data from excel. Since, "Row" and "Column" are integer, it is easy to use inside a loop. 

[JLogan3o13]

@Danyfirex happens to all of us. Glad you got it worked out