DDT Help

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.