Question #653769 on Sikuli changed:
https://answers.launchpad.net/sikuli/+question/653769
Status: Answered => Open
Muthumanikandan is still having a problem:
I debug the code with print statement, my analysis are:
Script:
import xlrd
import datetime
EXCELFILE = "D:\\Muthu\\Datamanipulation\\book2.xlsx"
book = xlrd.open_workbook(EXCELFILE)
sheet = book.sheet_by_index(0)
for rx in range(sheet.nrows):
value = sheet.cell_value(rx,33)
print(value) ## till this code prints column 33 all values (col 33 having 2
executable queries)
text_file = open("Output.sql", "w")
text_file.write(value) ## Here i am passing the column 33 values=2 executable
queries
text_file.write(Key.ENTER)
text_file.write("/")
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()
openApp("Script.bat")
wait(2)
print (value) # issue is here , here script prints only one value column 33
last value
Can anyone help to solve this problem:
text_file.write(value) ## while passing multiple values to DB it accepts
only last value.sometimes empty values passing but commit succesfull.
For screenshots refer below link:
https://screencast-o-matic.com/watch/cbjni8lB0B
--
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
