← Back to team overview

sikuli-driver team mailing list archive

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: Answered => Open

Muthumanikandan is still having a problem:
Thanks for the above Comment # 14,it  helped i am getting close to my
result, but one step ahead,

I tried below code:

import xlrd
import datetime
EXCELFILE = "D:\\Muthu\\Datamanipulation\\book2.xlsx"
book = xlrd.open_workbook(EXCELFILE)
sheet = book.sheet_by_index(0)
#print "value" + str(sheet.nrows)
for rx in range(sheet.nrows):
 print "contents: " + sheet.cell_value(rx,33)

Result:
Column 33 value of all rows is getting printed


instead of printing, i need to get the result in temporary variable and pass the variable value to text_file.write

for ex :
value = sheet.cell_value(40,33) ##value temp variable
text_file.write(sheet.cell_value(40,33)) ## passing variable value to text_file.write input

Kindly provide the code for the above scenario.

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