Read Excel data

[attractiveguy]

Hi, 

I searched a lot but couldn't find a solution, Please help me to sort out simple trick

I'd like to write a script ,which pick user name and password ,fill into a website and then wait for a function to complete and move to next row, I have tried many way but couldn't get through, If someone can please share the code, Shall be thankful,

[attractiveguy]

Hi, 

I searched a lot but couldn't find a solution, Please help me to sort out simple trick

I'd like to write a script ,which pick user name and password ,fill into a website and then wait for a function to complete and move to next row, I have tried many way but couldn't get through, If someone can please share the code, Shall be thankful,

[water]

AutoIt comes with an Excel UDF, each function comes with an example script. _Excel_RangeRead should be a good starting point.

[JLogan3o13]

Merged posts

[attractiveguy]

@water, thanks a lot for a prompt reply.

yes, that's the one , I am using, I am running the following code, it stops after reading all the cell, I'd like it read first cell and then enter these details to website,and then move to next cell. 

@water I am glad to see you here, I can see you are helping since 2008. I have already searched a lot,but couldn't the solution.please help.thanks a lot in advance

<autoit>

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

; Create application object
Local $oExcel = _Excel_Open()
Local $bReadOnly = False
Local $bVisible = True
Local $var = 1
Local $R = "D" & $var & ":" & "E" & $var
; ****************************************************************************
; Open an existing workbook and return its object identifier.
; *****************************************************************************
Local $sWorkbook = "D:\work\Variables\supplier\2016-2017\part01-31-07-2016.xlsx"
Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook, $bReadOnly, $bVisible)
Local $aResult = _Excel_RangeRead($oWorkbook, Default, $oWorkbook.ActiveSheet.Usedrange.Columns("D"), 1)
ConsoleWrite($aResult & @CRLF)
for $username In $aResult
   ConsoleWrite($username & @CRLF)
Next

</autoit>

[attractiveguy]

@JLogan3o13, not sure,how I posted second time,thanks for merging,

[Subz]

Try:

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

; Create application object
Local $oExcel = _Excel_Open()
Local $bReadOnly = False
Local $bVisible = True
Local $var = 1
Local $R = "D" & $var & ":" & "E" & $var
; ****************************************************************************
; Open an existing workbook and return its object identifier.
; *****************************************************************************
Local $sWorkbook = "D:\work\Variables\supplier\2016-2017\part01-31-07-2016.xlsx"
Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook, $bReadOnly, $bVisible)
Local $aResult = _Excel_RangeRead($oWorkbook, Default, $oWorkbook.ActiveSheet.Usedrange.Columns("D"), 1)
_ArrayDisplay($aResult)
For $i = 1 To UBound($aResult) - 1
    ConsoleWrite($aResult[$i] & @CRLF)
Next

 

[water]

If the Excel worbook isn't too large I would read the whole sheet and then process th returned array:

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


; Create application object
Local $oExcel = _Excel_Open()
Local $bReadOnly = False
Local $bVisible = True
Local $var = 1
Local $R = "D" & $var & ":" & "E" & $var
; ****************************************************************************
; Open an existing workbook and return its object identifier.
; *****************************************************************************
Local $sWorkbook = "D:\work\Variables\supplier\2016-2017\part01-31-07-2016.xlsx"
Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook, $bReadOnly, $bVisible)
Local $aResult = _Excel_RangeRead($oWorkbook)
For $i = 0 To UBound($aResult, 1) - 1
   Consolewrite($aResult[$i][3] & @CRLF) ; Column D
Next

 

Edited April 26, 2017 by water

[attractiveguy]

@Subz, Thanks a lot, community is really excellent,but unfortunately I wasn't mean that, sorry if I couldn't  explain properly.

after reading first row, it assign value to a variable and then put value into website, after first cell completion ,it should pick the second value, I am attaching php code to explain. which I can achieve through php. $R will print before adding 1 to $var1. 

 $var1 = 1;

 

 while ($var1<=10){
      $R = "D";
    $C = "E$";
    echo "$R<br>";
    
    $var1++;
 }    

[attractiveguy]

@water, Unfortunately code is not stopping to assign value  to a variable.  it just keep reading until end.

[water]

Some questions regarding your PHP code:

• Why do you increment $var1 in a loop and  then not use it in the loop?
• The same is true for $C. It gets a string assigned but is not referenced in the loop.

[attractiveguy]

Please forget the $C,  I am assign $var1 to $R. $R is equal to"D(coloumn)$var1"; so by changing $var1 value, I am going to next row each time. 

[attractiveguy]

Okay, I think ,I have figured it out. But the support from the community is excellent. I really appreciate all you guys for help me this, I spent two days to figure it out. Special thanks to @water and @Subz

[water]