Hi,
The customer has presented me with a table that has small, pre-printed integers in the top, left corner of each cell of the table.
Please see attached screen shot.
I want to exclude each of those small rectangles from the region of each cell.
I understand the concept of the Flexilayout Language Exclude function.
Question:
How can I get the coordinates of each table cell, such that I can calculate the small, upper-left rectangle to exclude?
Thx,
M.
Comments
5 comments
Hello,
Is it possible for you to use repeating groups?
Hi,
Thank you. I have made great progress using a nested set of repeating groups: rows and columns yield cells.
I understand that I need to create an Exclude of the small rectangle that contains the text I need to ignore.
That rectangle is always 30 dots by 30dots, in the upper left corner of the search area of each cell.
Question:
In the Advanced pre-search, how do I access to search area (not the hypothesis region) of the cell?
Thx,
M.
Hello,
As we understood, you were already able to find the cell's rectangles. In this case you may exclude the upper left corner area of each cell using the following approaches:
1) at first, find in this cell area a character string you want to exclude. Then, when you will search the main value in the cell, exclude the previously found element.Rect (Exclude: <your element>.Rect; see the screenshot).
2) or you may use a complex region formed in the Advanced relations with the help of RectArray (see the screenshot):
let RA = RectArray();
RA.Add( Rect(RegionElement.Rect.Left + 100dt, RegionElement.Rect.Top, RegionElement.Rect.Right, RegionElement.Rect.Top + 100dt) );
RA.Add( Rect(RegionElement.Rect.Left, RegionElement.Rect.Top + 100dt, RegionElement.Rect.Right, RegionElement.Rect.Bottom) );
RSA: RA.Region;
Concerning your original question, if you already have delimited cells' rectangles, you may use their properties as search areas for all cell contents, so if you haven't yet found the cell rectangles, we recommend to do it using table's separators as delimiters.
Please sign in to leave a comment.