SikuliX

Recognigze text in a program and use it in an other program

Asked by Joop Meloen

Hello,

I am not very familiar with sikuli but i need it to solve a problem

I have a column with numbers in excel. When one of this numbers will change, I want that sikuli recognize the changed text and copy it in an other program. Just copy and past is not possible, because the other program do not accept that.

Could any one tell me how i have to get the text from excel when it changes en put it in a cel of the other program. Sikuli have to control the whole column and if one of the numbers will change it has to copy that changed number to the other program. And after that, Sikuli have to check the column again and again and again for changes.

I hope that anyone can help me with this.

Thanks in advance.

Kind Regards,

Joop Meloen

Question information

Language:
English Edit question
Status:
Answered
For:
SikuliX Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
RaiMan (raimund-hocke) said : 		#1

-- how often does one of the numbers change per minute?

-- how is the exec file triggering the change? have a screenshot?

-- what kind of program is the target app: desktop or web app? have a screenshot?

-- if you have the number, is it possible to paste the number into the target app?

-- what is your scripting/programming experience? (e.g. write VisualBasic macro in Excel?)

Revision history for this message
Joop Meloen (joop-meloen) said : 		#2

 the number will change about once a minute

The change will be triggered by an visual basic program

The target app is a web app

Like I mentioned in my messages above, it is not possible to paste the number into the target app.

I have some expierence with visual basic in excel but that is all.

I m sorry but i can't take screenshots at this moment because my computer is acting weird.

Hope you can help me with this

Joop

Revision history for this message
RaiMan (raimund-hocke) said : 		#3

I already had a case in the past like that.

The solution is to let the VB script save the excel sheet after having made the changes.
then the Sikuli script detects the change of the column visually and reads the saved xls using the python module xlrd, that allows to grab the numbers from the saved worksheet.

Now it is normal automation: click the fields in the web app and type the numbers.

we should continue to communicate privately: find my mail here: https://launchpad.net/~raimund-hocke

Revision history for this message
Joop Meloen (joop-meloen) said : 		#4

Alright that is nice to hear,

But couldn't you explain it here on the forum in public, because maybe there are other people with the same problem who can also take profit from it in the future.

Joop

Revision history for this message
RaiMan (raimund-hocke) said : 		#5

for the other solution I have given a non-disclosure agreement.

So if you are interested, then we should go ahead and use whatever channel to communicate.
In the end you may decide to publish your solution.

Lets start with the exact needs.
- a step by step description of the workflow
- relevant screen shots
- code snippets you might already have
… whatever helps.

Can you help with this problem?

Provide an answer of your own, or ask Joop Meloen for more information if necessary.

To post a message you must log in.