How to read values from Excel using Autoit

[Arka]

Example: Say i have 2 values "true" in excel "A3" field & "false" in excel "B3" field.

Please help me out, how to create a autoit script for the above.

[Arka]

Just now, Arka said:

Example: Say i have 2 values "true" in excel "A3" field & "false" in excel "B3" field.

Please help me out, how to create a autoit script for the above.

 

Book1.xlsx

[water]

Welcome to AutoIt and the forum!

Please have a look at the Excel UDF that comes with AutoIt, function _Excel_RangeRead.

[Arka]

Thank You..

Is it possible, based on excel data my script will work.

EX: If value is "true" in excel my script will execute something & if its "false" then it will execute something else.

[Arka]

Please give me a autoit script example. For the above post.

[water]

We do not spoon feed users here.
Check the example scripts that come with each command in the help file. Should be easy to modify them to your needs.

[Arka]

Watch your words. I am not asking any nonsense knowledge from you.

[water]

You do not ask any nonsense, but you do not show any effort either.
Check the help file for _Excel_RangeRead and ask what goes wrong after you have modified the script to your needs.

[Arka]

Hey i did that. Codes are below:

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

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, @ScriptDir & "\Book1.xlsx")
If @error Then
     MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example", "Error opening workbook '" & @ScriptDir & "\Book1.xlsx'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
    _Excel_Close($oExcel)
    Exit
 EndIf


Local $sResult = _Excel_RangeRead($oWorkbook, Default, "A3")
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 1", "Error reading from workbook." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeRead Example 1", "Data successfully read." & @CRLF & "Value of cell A3: " & $sResult)

 

Can you help me now, that how to read multiple rows value say A3,B3,C4. Here: Local $sResult = _Excel_RangeRead($oWorkbook, Default, "A3")

[water]

Th best description how to select a Range can be found in the wiki: https://www.autoitscript.com/wiki/Excel_UDF#Range and https://www.autoitscript.com/wiki/Excel_Range

[mLipok]

@Arka please read:  How to post code on the forum 

And, welcome to the forum.

mLipok

 

[232showtime]

On 7/16/2016 at 9:54 PM, Arka said:

Watch your words. I am not asking any nonsense knowledge from you.

Let me tell you something, water is the one who made this excel UDF, that you are asking about,

so I think you're the one who needs to be polite, you are asking help, be polite and show some effort. show some respect dude. you're lucky water still replied to your post.

 

you didn't even use the code tags.

Edited July 18, 2016 by 232showtime
added some line :P

[Arka]

Sorry Water. Thanks for the help.

[Arka]

Local $sResult = _Excel_RangeRead($oWorkbook, Default, "B6:B7")

This code is not reading 2 cells values B6,B7 from excel.

@water Can you tell me what is wrong here?

[BrewManNH]

_Excel_RangeRead returns an array when you ask it to read a range of cells, and a string when you ask it to read from a single cell. You're accessing the variable wrong.

[Arka]

I am trying to read 2 string value say "True & false" but using that i am not able to. Any wiki or any source will be great for accessing these arrays.

[JLogan3o13]

1 hour ago, Arka said:

I am trying to read 2 string value say "True & false" but using that i am not able to. 

@Arka this "it's broke" response tells us nothing. You have several members trying to assist, but getting information thus far has been like pulling teeth. Are you getting an error, or is it just not finding the text? Help us help you

Edit: I have also moved this to the General Help and Support forum, as the Developer forum clearly states at the top "Do not post AutoIt related topics here".

Edited July 21, 2016 by JLogan3o13

[SadBunny]

1 hour ago, Arka said:

Any wiki or any source will be great for accessing these arrays.

As you know, Google and the helpfile are always your friend. Check under "Arrays": https://www.autoitscript.com/autoit3/docs/intro/lang_variables.htm

[water]

There is a wiki tutorial about arrays. "Everything you always wanted to know about arrays but were afraid to ask"

[Arka]

Thanks for the help.