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:
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.