← 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

Manfred Hampl posted a new comment:
You cannot give more than one cell address to  sheet.cell_value() and
similar functions, but you have to use some kind of loop statements.

something similar to

    ...
    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()

This loops through all rows. If this is not correct, e.g. because the
data start only in row 20, you have to formulate the looping statement
different, probably something like

    for rx in range(20, sheet.nrows):

This is python coding. You should try improving your knowledge in python
programming.

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