sikuli-driver team mailing list archive
-
sikuli-driver team
-
Mailing list archive
-
Message #26217
[Question #249639]: Drag and drop a shape from stencil to worksheet in visio
New question #249639 on Sikuli:
https://answers.launchpad.net/sikuli/+question/249639
I wanted to automate the following scenario using sikuli
• Create a spread sheet which contains the “shape name” of visio
o Ex. Rectangle,Square, Circle
o The spread sheet ( csv) has two column . 1st column shape name and 2nd column contains “Yes” or “No”
o If the column contain the word “yes” then the respective shape dragged from the stencil to the worksheet
o Once it placed the worksheet , the shape has to be double clicked to enter the data
So how do I achieve this work flow? . Since I am able to refer the data from csv file and able to print in the console, but not aware how do I link the OCR here to find the shape and drag it to worksheet.
*** Here is my code*********
fob1 = file(r"C:\SikuliX\BackUp\fc1.csv")
for line1 in fob1:
(a1, b1) = line1.strip().split(',')
if (a1 =="OR" and b1=="Yes"):
print(a1)
print(b1)
type(a1)
# (Here i need the code to drag and drop the shape from stencil to worksheet based on "a1" and after that i needs to double click on it )
fob= file(r"C:\SikuliX\BackUp\fc.csv")
#fob.read()
for line in fob:
#print(line)
#type(line)
(a, b, c, d, e, f, g, h, i, j, k, l,) = line.strip().split(',')
if( a == "OR" ):
#Settings.i1 = a
Settings.i2 = b
Settings.i3 = c
Settings.i4 = d
# Settings.i5 = e
# Settings.i6 = f
# Settings.i7 = g
# Settings.i8 = h
# Settings.i9 = i
Settings.i10 = j
Settings.i11 = k
Settings.o1 = l
#print(a)
print(b)
print(c)
print(d)
# print(e)
# print(f)
# print(g)
# print(h)
# print(i)
print(l)
--
You received this question notification because you are a member of
Sikuli Drivers, which is an answer contact for Sikuli.