← 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

Muthumanikandan posted a new comment:
 i am a tester i will improve by practice..

1)  i tried this comment#12 code

sheet = book.sheet_by_index(0)

    text_file = open("Output.sql", "w")

    for rx in range(sh.nrows):
        text_file.write(sheet.cell_value(rx,33)
        text_file.write("\ncommit;")

    text_file.close()

it fetch only single row value , for ex: fetched only row 33 value..

2) with the above example i tried to fetch column value

text_file = open("Output.sql", "w")

    for rx in range(sh.ncols):
        text_file.write(sheet.cell_value(rx,33)
        text_file.write("\ncommit;")

    text_file.close()

i got this error:

[error] IndexError ( index out of range: 5 )
[error] --- Traceback --- error source first line: module ( function ) statement 413: sheet ( cell_type ) IndexError: index out of range: 5

Can anyone help me with example how to fetch multiple record,
for ex: row40,col33
row41,col33
row42,col33

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