Hello again,
I just find out that the issue is cause by not closing the driver in the methods that I called in my code.
DDT.CloseDriver(DDT.CurrentDriver.Name);This line solved issue for me.
I really hate this new forum - I had earlier saw a screenshot of your spreadsheet (I think it was yours!), which I can't seem to find now!
From what I remember from the screenshot, columns C, D and E on row 3 had a few empty values. This might cause issues with DDT.ExcelDriver, or you might need to deal with empty value or error that's returned by DDT.CurrentDriver.Value() method.
I suggest you try the example that I have provided, but include all column to output the values, e.g.
var a = DDT.CurrentDriver.Value("Column A");
Log.Message(a);
var b = DDT.CurrentDriver.Value("Column B");
Log.Message(b);
var c = DDT.CurrentDriver.Value("Column C");
Log.Message(c);
DDT.CurrentDriver.Value("and so on");
...This will given an indication as to what row and column is causing the issue.
With DDT, you need to ensure that the headers are correctly formatted, and the data is correctly formatted too.
Here's an example where column F does not exist, error message is shown.
Here is my Excel Sheet.
And I only use PersonID and LastName columns.
Same spread sheet works with some other function but not with my main function.
