Maintain rows when using copy/paste to a Table Variable

The limitation is, that when using Excel files (or other external data files, CSV, etc), you cannot iterate just one 1 row in each test run. This limitation is best described using an example. I use Keyword testing by the way.

Here is an example of what I mean:

testdata (for example, in Excel file):

row 1: testdatastring1

row 2: testdatastring2

row 3: testdatastring3

etc.

In a keywordtest I have a command:

keys (data from testdata file (Excel file);

(to put the testdatastring1 in an input field in some application.)

This works fine in a Dataloop, but it has following limitations:

you can only iterate to the end of the file, or a number records (start / end row);

HOWEVER, I want to achieve following:

In each test run, the next row should be picked out of the Excel file.

Starting on row 1. Next execution row 2, next 3. etc.

But not in a continious mode (like datadriven).

When the second test run is executed, TestComplete is closed/ , and next day TestComplete / same test is started again, then when same test is run, the next row (3 in this case) is picked from the Excel file.

As far as I can see, This is currently only possible when using Data Table Variable, in combination with using a persistent variable as a row index. But, because you cannot define the row index when using external data files (Excel, CSV), the above scenario is not possible when using Excel files.

Hope this is clear what I mean....