sikuli-driver team mailing list archive
-
sikuli-driver team
-
Mailing list archive
-
Message #43331
Re: [Question #653769]: How to run a executable query in Oracle -Sql Developer
Question #653769 on Sikuli changed:
https://answers.launchpad.net/sikuli/+question/653769
Status: Needs information => Open
Muthumanikandan gave more information on the question:
Yes Now i can get value from excel by using following code,
import xlrd
import datetime
EXCELFILE = "D:\\Muthu\\Datamanipulation\\book1.xlsx"
book = xlrd.open_workbook(EXCELFILE)
sheet = book.sheet_by_index(0)
celltype = sheet.cell_type(40,33)
value = sheet.cell_value(40,33)
but i need to pass this value to "text_file.write" so that my value will
got insert into DB.
text_file.write("Insert into emp_details
(EMP_ID,EMP_NAME,EMP_ADDRESS,DESIGNATION,QUALIFICATION,AGE) values
(917,'Muthu','Covai','PA','BE',21);")
Help to pass the value to text_file.write , sometimes i need to insert
multiple rows so provide code for multiples rows also
--
You received this question notification because your team Sikuli Drivers
is an answer contact for Sikuli.