Forum Discussion
tristaanogre
13 years agoEsteemed Contributor
DDT Driver objects iterate row by row so there's no easy way, given a particular driver object, to go to a specific row and find a value without looping through all the rows.
The alternative is to pass through to the driver object a command text that is, in essence, an SQL query that limits the records returned... however, doing so would alter the record set in the driver object.
The BEST way to get a particular value from a particular row and column in an excel doc is to use the Excel application COM object. You can probably adapt the code found at http://smartbear.com/support/viewarticle/20878/ to, instead of writing to a cell, getting the value of that cell.
The alternative is to pass through to the driver object a command text that is, in essence, an SQL query that limits the records returned... however, doing so would alter the record set in the driver object.
The BEST way to get a particular value from a particular row and column in an excel doc is to use the Excel application COM object. You can probably adapt the code found at http://smartbear.com/support/viewarticle/20878/ to, instead of writing to a cell, getting the value of that cell.
Related Content
Recent Discussions
- 4 hours agoashly