I have test data in Excel, but because of current limitations of TC in Data driven testing, I need to use Data Table Variables. When using copy / paste to copy the data out of Excel into the Table V...
Yes, it would read the whole sheet every time but that's actually relatively quick.
Not a lot of coding, just a loop to manage the index. The rest of the test is the same as it would be otherwise.
We also use it when we want to group data. Say we have a list of parts that for most tests we want to use the whole list but sometimes we want to just run it for the parts that are a certain color. Then we would use a parameter to look for the rows that have that color and do the test. That's still a sort of index but it would find more than one row in that case.