SikuliX

Using Excel data as input, im stuck here! :(

Asked by Stephan Timmers

Hi,

My idea is to let SikuliX:
> start at a point
> fill in first number on a list (Excel)
> complete entire script
> end at starting point
> fill in next number (Excel)

I have written the script and i will paste it below. I dont think the images work, i'm very new to this forum and would like to know if i can enhance the way i preview my script to you guys.

wait("1462293000284.png")
click("1462293000284.png")
wait("1462293050774.png",2000)
click("1462293050774.png")
wait("1462293083605.png",2000)
click("1462293083605.png")
wait("1462293111878.png",2000)
doubleClick(Pattern("1462293111878.png").targetOffset(-37,11))
'Here should the value from A2 (Excel) be filled in'
paste("value from A2"\n)
wait("1462293510916.png",2000)
doubleClick(Pattern("1462293510916.png").targetOffset(169,0))
'Here should the value from B2 (Excel) be filled in'
paste("value from B2"\n)
wait("1462293671098.png",2000)
click(Pattern("1462293671098.png").targetOffset(123,78))
waitVanish("1462293671098.png",2000)
doubleClick(Pattern("1462293761014.png").targetOffset(248,1))
'Here should the value from C2 (Excel) be filled in'
paste("value from C2"\n)
doubleClick(Pattern("1462293931637.png").targetOffset(240,0))
'Here should the value from C2 (Excel) be filled in'
paste("value from C2"\n)
wait("1462294030778.png",2000)
click(Pattern("1462294030778.png").targetOffset(109,44))
waitVanish("1462294030778.png",2000)
'At this point I would want the script to loop with the values of A3, B3 and C3 untill it reaches an empty cell then end'

Below a link to:
1. A document with my script with images.
2. The Excel file in .xls (as I have read .xlsx doesn't work).

WeTransfer link to above files:
https://we.tl/XrG8qNpa8y

I thank all of you who spare time to help me in advance,
Greetings, Stephan, 24 year old Dutch newbie.

Question information

Language:
English Edit question
Status:
Expired
For:
SikuliX Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Roman Podolyan (podolyan-roman) said : 		#1

) If you want others to see your complete script, Sikuli does "double-save" , and copy of your script with images is saved as .html file . You can use then some browser extension which allows to "Save all page as image" (look at browser extensions sites)
) Do you consider .CSV export from Excel as input?

Revision history for this message
Stephan Timmers (stephan-timmers-1991) said : 		#2

Thanks I understand now. I have uploaded a copy of it as a document. Will
use the html next time or If needed today.

I dont really mind what way of inport or export I use as long as it works.
Stil got No clue how I should place it in my script tho.

TLDR: Yes im fine with CSV export
Op do 5 mei 2016 om 08:57 schreef Roman Podolyan <
<email address hidden>>

> Your question #293205 on Sikuli changed:
> https://answers.launchpad.net/sikuli/+question/293205
>
> Status: Open => Needs information
>
> Roman Podolyan requested more information:
> ) If you want others to see your complete script, Sikuli does
> "double-save" , and copy of your script with images is saved as .html file
> . You can use then some browser extension which allows to "Save all page as
> image" (look at browser extensions sites)
> ) Do you consider .CSV export from Excel as input?
>
> --
> To answer this request for more information, you can either reply to
> this email or enter your reply at the following page:
> https://answers.launchpad.net/sikuli/+question/293205
>
> You received this question notification because you asked the question.
>

Revision history for this message
Stephan Timmers (stephan-timmers-1991) said : 		#3

Any one knows a solution? Im still stuck!
Op do 5 mei 2016 om 09:17 schreef Stephan Timmers <
<email address hidden>>

> Your question #293205 on Sikuli changed:
> https://answers.launchpad.net/sikuli/+question/293205
>
> Status: Needs information => Open
>
> You gave more information on the question:
> Thanks I understand now. I have uploaded a copy of it as a document. Will
> use the html next time or If needed today.
>
> I dont really mind what way of inport or export I use as long as it works.
> Stil got No clue how I should place it in my script tho.
>
> TLDR: Yes im fine with CSV export
> Op do 5 mei 2016 om 08:57 schreef Roman Podolyan <
> <email address hidden>>
>
> > Your question #293205 on Sikuli changed:
> > https://answers.launchpad.net/sikuli/+question/293205
> >
> > Status: Open => Needs information
> >
> > Roman Podolyan requested more information:
> > ) If you want others to see your complete script, Sikuli does
> > "double-save" , and copy of your script with images is saved as .html
> file
> > . You can use then some browser extension which allows to "Save all page
> as
> > image" (look at browser extensions sites)
> > ) Do you consider .CSV export from Excel as input?
> >
> > --
> > To answer this request for more information, you can either reply to
> > this email or enter your reply at the following page:
> > https://answers.launchpad.net/sikuli/+question/293205
> >
> > You received this question notification because you asked the question.
> >
>
> --
> You received this question notification because you asked the question.
>

Revision history for this message
Launchpad Janitor (janitor) said : 		#4

This question was expired because it remained in the 'Open' state without activity for the last 15 days.