← Back to team overview

sikuli-driver team mailing list archive

Re: [Question #247029]: While loop in combination with a blank row in Excel

 

Question #247029 on Sikuli changed:
https://answers.launchpad.net/sikuli/+question/247029

    Status: Open => Answered

RaiMan proposed the following answer:
Why don't you use the packages xlrd and xlwt? (faq 2208)

Navigating visually in an excel sheet is rather complex and error prone.

Nevertheless: An option in between, supposing even line heights:

- evaluate the line height
- start with top left cell
- go to next cell by adding line height to top left corner of current cell
- check cell content using an image of blank cell
- go down until you find a blank cell

This is generally the best approach for some table oriented GUIs or
screen content, that has some identifiable raster behind: if you know
this raster or be able to evaluate it somehow, you can go to every cell
of the layout only by calculating positions/dimensions.

The new version 1.1.0 will have some support for that: you can split a
region into rows and/or colums, so that the respective elements are
accessible by a table index.

-- 
You received this question notification because you are a member of
Sikuli Drivers, which is an answer contact for Sikuli.