Forum Discussion

murugans1011's avatar
murugans1011
Regular Contributor
11 years ago

DDT Help

While performing DDT using Excel 'DDT.CurrentDriver.Next' focus next row in excel.is there anyway tat we can set focus to the particular row?
  • karkadil's avatar
    karkadil
    11 years ago

    function excel2array()


    {


      var excel = DDT.ExcelDriver("C:\\data.xls", "Sheet1");


      


      var data = []; // array to store all rows


      while(!excel.EOF())


      {


        var row = []; // array for storing data from a single row


        for(var i = 0; i < excel.ColumnCount; i++)


        {


          row.push(excel.Value(i));


        }


        data.push(row);


        excel.Next();


      }


      DDT.CloseDriver(excel.Name);


    }



    At the end, the data array will contain all data from the Excel sheet. To access a particular cell:

    data[0][1] - contains value from row 0, column 1, etc.

karkadil's avatar
karkadil
Valued Contributor
11 years ago

function excel2array()


{


  var excel = DDT.ExcelDriver("C:\\data.xls", "Sheet1");


  


  var data = []; // array to store all rows


  while(!excel.EOF())


  {


    var row = []; // array for storing data from a single row


    for(var i = 0; i < excel.ColumnCount; i++)


    {


      row.push(excel.Value(i));


    }


    data.push(row);


    excel.Next();


  }


  DDT.CloseDriver(excel.Name);


}



At the end, the data array will contain all data from the Excel sheet. To access a particular cell:

data[0][1] - contains value from row 0, column 1, etc.