I need to copy data from excel sheet and past in desktop application

[Menna]

I need to create a script read values from excel sheet cell by cell then added in calculator 

[water]

Welcome to AutoIt and the forum!

What have you tried so far?

[Menna]

i tried to copy list of values from excel sheet cell by cell and past it in another excelsheet 

[water]

You did notice that AutoIt comes with an Excel UDF (library of User Defined Functions)?

Edited June 6, 2020 by water

[Menna]

no i need a a simple from the code do copy from excel sheet cell by cell then past it in notebad 

[water]

That's exactly what you can do with this UDF. Functions _Excel_RangeRead or _Excel_RangeCopyPaste should do what you want to do.
Have a look at the help file. There are a lot of examples too.

[Menna]

i have create and find this example and still find an issue as the script looping 

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


;Essentially i am trying to copy an excel cell, paste it somewhere go back to excel, go down a cell and repeat untill the cell is blank

Local $oExcel = _Excel_Open()
Local $sWorkbook = @ScriptDir & "\Book1.xls"
Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook)

;Unsure if instead of using a cell range i should be getting excel to read one cell, then in the next loop add a 1 to the cell and read again. Eg. Read A1 do function, read A2 do function
Local $aResult = _Excel_RangeRead($oWorkbook,1, "A1:A14")

Do
   WinActivate("Microsoft Excel - Book1.xls")
   Send("{CTRLDOWN}c{CTRLUP}")
   ;Copy cell
   WinActivate("Untitled - Notepad")
   Send("{CTRLDOWN}v{CTRLUP}")
   ;Paste cell
   WinActivate("Microsoft Excel - Book1.xls")
   ;Go down a cell
   Send("{ENTER}{ENTER}")
Until $aResult = ""

Exit

[water]

I suggest:

#include <Excel.au3>

Local $oExcel = _Excel_Open()
Local $sWorkbook = @ScriptDir & "\Book1.xls"
Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook)
Local $aResult = _Excel_RangeRead($oWorkbook, 1, "A1:A14")

WinActivate("Untitled - Notepad")
For $i = 0 to UBound($aResult, 1) - 1
   Send($aResult[$i] & @CRLF)
Next
Exit

 

Edited June 7, 2020 by water
Added @CRLF so each value goes to a separate line

[Menna]

Thanks so much for your support but when when I'm tried i found that the result displayed all values in the same line and also i need to copy first item then make a manipulation once done will go to copy another one and so on 

Edited June 7, 2020 by Menna

[water]

I added a @CRLF to my script above so each value gooes to a seprate line.

What do you mean with "manipulation"? In the AutoIt script? In Notepad?

[Menna]

i will add @CRLF 

i need to copy one value in cell then i will add to the application text box 

then i will click button in the application as submittion , and check the data displayed successfully in the application 

Then back to the sheet and copy the another cell so back to the app and submit the another one and so on 

[water]

Then I suggest to use the following commands: ControlSend to send the data to your application, ControlClick to click the button and WinWait to wait until processing has ended.

[Menna]

iam using a mouse click for controlclick , there is any solution becouse the application has no id for class name or instance  ?

 

[water]

It's hard to tell without knowing which application we are talking about.