Copy Pasting Excel cell value to application

[ShrutiW]

Can I paste a value copied from a cell in the excel sheet to the text box in an application? using like ClipGet() or any other functions?  Is it possible?

Here's the code that I've tried so far. 

Local $oRange = $oWorkbook.ActiveSheet.Range("A1:R1")  ; Reading excel sheet
_Excel_RangeCopyPaste($oWorkbook.ActiveSheet, $oRange, "E1")  ;copying value from cell "E1"
 Local $sData = ClipGet()
WinWait ("New Contact","")     ; Activating the window of application where I want to paste the cell value
WinActivate("New Contact","")
WinWaitActive("New Contact")
Sleep(2000)
ControlGetHandle("New Contact",ClipGet() , "[CLASS:ThunderRT6TextBox ; INSTANCE:6]")     ;TextBox where I want to paste the copied value

 

[water]

No need to use _Excel_RangeCopyPaste. Simply use _Excel_RangeRead to read the cell value to a variable and then use ControlSend to"paste" the value to the other application.

[ShrutiW]

Hi @water,

I tried using ReadRange, didn't get result . Please have a look at the code.  

Local $aResult = _Excel_RangeRead($oWorkbook, Default, $oWorkbook.ActiveSheet.Usedrange.Columns("A:R"), 1)
 Local $sResult = _Excel_RangeRead($oWorkbook, Default, "E2")
 WinWait ("New Contact","")
 WinActivate("New Contact","")
 WinWaitActive("New Contact")
 Local $hWnd = WinWait("New Contact","")
 Sleep(2000)
 ControlSend($hWnd,$sResult ,"[CLASS:ThunderRT6TextBox ; INSTANCE:6]" , "")

What changes are expected?

[Nine]

ControlSend is badly formated...read help file carefully.

[ShrutiW]

Hi @Nine, I am confused about how to use the parameter "$sResult" in controlSend command? 

[FrancescoDiMuro]

@ShrutiW

ControlSend ( "title", "text", controlID, "string" [, flag = 0] )

- Title: the title/hwnd of the window where the control exists;

- Text: the text of the window where the control exists (you can leave it blank);

- ControlID: the control ID/handle/text... of the control, in order to interact with it;

- String: the string to send to the control;

- Flag: how to send the string:

- Use $SEND_DEFAULT (0) to send special characters like + or !, which are respectively Shift and Alt key presses;

- Use $SEND_RAW (1) to send the text as is to the control.

Switch your second parameter with the fourth one in the ControlSend function, and you should be done

Edited April 1, 2019 by FrancescoDiMuro

[ShrutiW]

Hey @FrancescoDiMuro, As per your suggestions I made changes in ControlSend command as :-

ControlSend($hWnd,"","[CLASS:ThunderRT6TextBox ; INSTANCE:6]" ,$sResult)

I am not getting the desired result .

Edited April 1, 2019 by ShrutiW

[water]

What's the return value of ControlSend?

[ShrutiW]

Hi @water, I have used $sResult variable to store the value in the cell, and I am passing "$sResult" as a return value in control send. Is it a right way to do? 

[water]

You need to define "not desired result".
Do you get no text in the control, the wrong text (e.g. characters missing, wrong encoding) or do you get an error?
To check for an error you need to have a look at the return value:

$iReturnValue = ControlSend($hWnd,"","[CLASS:ThunderRT6TextBox ; INSTANCE:6]" ,$sResult)
If $iReturnValue <> 1 Then MsgBox(0, "Error!", "window/control is not found!")

 

[ShrutiW]

Hi @water, I checked with above code,I do not get any text in the control.  Got an error message box.

Edited April 1, 2019 by ShrutiW

[water]

The error message describes what happens:
Either the window or control could not be found.
As the window handle has been derived from a WinWait it seems that the control could not be found.
Searching for "ThunderRT6" shows a lot of threads describing problems with this type of controls. Maybe one of them sheds some light onto the subject and delivers a solution?

 

[ShrutiW]

Hi @water, It is not working in either way, It is getting in over my head now.😥 Is there any other way I can retrieve cell values from excel and send them to text boxes and combo boxes in a windows application? 

[FrancescoDiMuro]

You should try SimpleSpy from UIAutomation (you can find more here)

[water]

The part about reading Excel values has been solved.
If your application provides an API for automation I would use this and drop automating the GUI. Have a look at the documentation of your application and see if you find something about COM, API or programming.

[ShrutiW]

Okay @water. I will check. Thanks for the advice and help. 😃