Question #653769 on Sikuli changed:
https://answers.launchpad.net/sikuli/+question/653769
Muthumanikandan posted a new comment:
how can i pass the multiple values
for ex: text_file.write(sheet.cell_value(32,30)) this script pass one value,
if i need to pass multiple values should i do like this
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),(41,43),(42,43)
value = sheet.cell_value((40,33),(41,43),(42,43))
wait(2)
text_file = open("Output.sql", "w")
text_file.write(sheet.cell_value((40,33),(41,43),(42,43))
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 GPCPRD/HEROGPC@DB10:1521/ORCL.CORP.SIERRATEC.COM
@%NetPath%/Output.sql")
batch_file.write("\nexit")
batch_file.close()
--
You received this question notification because your team Sikuli Drivers
is an answer contact for Sikuli.
_______________________________________________
Mailing list: https://launchpad.net/~sikuli-driver
Post to : sikuli-driver@lists.launchpad.net
Unsubscribe : https://launchpad.net/~sikuli-driver
More help : https://help.launchpad.net/ListHelp
