Visual Studio data-driven tests

Question

Hi,

I'm using a TextContext property to access the current row in an Excel file. The test is repeated for all rows. Is it possible to access all rows in a single step? Rows are related, hence for me one sheet should be a complete run.

Edit: I add some code as requested:

int result = this.TextContext.Rows[0]["GlobalResult"];
foreach(var row in this.TestContext.Rows.Skip(1))
{
    componentToTest.Eval(Convert.ToInt32(row["A"]), Convert.ToInt32(row["B"]));
}
Assert.AreEqual(result, componentToTest.Result);

And the file would appear like this:

GlobalResult, A, B 100, null, null null, 1, 5 null, 3, 6 ... and so on

Thank you very much