sikuli-driver team mailing list archive

[Muthumanikandan <question653769@xxxxxxxxxxxxxxxxxxxxx>]

Question #653769 on Sikuli changed:
https://answers.launchpad.net/sikuli/+question/653769

Muthumanikandan posted a new comment:
i found the solution for above problem,

here is my code:

text_file = open("Output.sql", "w")
text_file.write("Insert into emp_details (EMP_ID,EMP_NAME,EMP_ADDRESS,DESIGNATION,QUALIFICATION,AGE) values (917,'Muthu','Covai','PA','BE',21);")
text_file.write("\ncommit;")
text_file.close()

batch_file=open("Script.bat","w")
batch_file.write("set NetPath=%~dp0")
batch_file.write("\n@echo off")
batch_file.write("\nsqlplus -L OPCPRD/OPCDGPC@DB10:1521/ORCL.CORP.SIERRATEC.COM @%NetPath%/Output.sql")
batch_file.write("\nexit")
batch_file.close()

openApp("Script.bat")
wait(1)
closeApp("Script.bat")

by this code my values successfully inserted into Db.

I need to know how to copy from excel clipboard via sikuli script, and
paste the value in following code,

text_file.write("Insert into emp_details
(EMP_ID,EMP_NAME,EMP_ADDRESS,DESIGNATION,QUALIFICATION,AGE) values
(917,'Muthu','Covai','PA','BE',21);")

-- 
You received this question notification because your team Sikuli Drivers
is an answer contact for Sikuli.