Forum Discussion

DarkShadows's avatar
DarkShadows
Contributor
8 years ago
Solved

TestComplete_WebApplication_DDTDriver_How to pass the Specific Row value in scripts?

Hello Team,   I'm stuck at how to pass specific row's value in my script, currently i'm able to pass the first row value however how to pass the second or third row values?   Really appracite if ...
  • baxatob's avatar
    baxatob
    8 years ago

    Hi,

     

    If you need to iterate through all values:

     

    function CheckProps() {

    ExcelPath = 'C:\\Stores\\ExWorksheet.xlsx';
    Driver = DDT.ExcelDriver(ExcelPath , "Sheet1");    
    Driver.First();
    
    while (! Driver.EOF()) {
        for (i=0; i<Driver.ColumnCount; i++) {
            Log.Message(Driver.Value(i));
            }
        Driver.Next();
        }
    }
baxatob's avatar
baxatob
Community Hero
8 years ago

Hi,

 

If you need to iterate through all values:

 

function CheckProps() {

    ExcelPath = 'C:\\Stores\\ExWorksheet.xlsx';
    Driver = DDT.ExcelDriver(ExcelPath , "Sheet1");    
    Driver.First();
    
    while (! Driver.EOF()) {
        for (i=0; i<Driver.ColumnCount; i++) {
            Log.Message(Driver.Value(i));
            }
        Driver.Next();
        }
    }