Solved
Forum Discussion
tristaanogre
7 years agoEsteemed Contributor
DDT driver does not return cell values. Basically, the DDT driver treats the excel sheet as a data table. You iterate through the rows (That's what Driver.Next does... it takes you to the next row). The "for" loops are not only not necessary... they won't work.
Since you want to iterate through every row and grab every column, then within the while loop, you simply need to call Driver.Value(<columnName>) for each column.
If you want to grab a specific cell value from an excel sheet, your better bet is to call Exce.Application COM object.