Set Driver = DDT.ExcelDriver("C:\MyFile.xlsx", "Sheet1", True)
Do Until Driver.EOF
For i = 0 To DDT.CurrentDriver.ColumnCount - 1
w3.wText = DDT.CurrentDriver.Value(i)
Test execution seems to stuck at the EOF, even when i only have 1 row of content, it will only bypass if i did not have any content
There is no iterating through the data. To iterate through it, add Driver.Next before Loop.
[ QUOTE ]
even when i only have 1 row of content, it will only bypass if i did not have any content
[/ QUOTE ]
The values of the first row cells are treated as column names. To retrieve column names, use DDT.CurrentDriver.ColumnName(i).
For more information, refer to the Using DDT Drivers help topic.
Allen - SmartBear Support