Using Array to get Excel data
Hi, I'm trying to get values (data) from excel, after using if and for loop to get rows and columns details, I'm trying to put the data to an array and then use the array to input the data from...
Forum Discussion
function TestExcelKnowRowIndex()
{
var Row = 1;
var Excel = Sys.OleObject("Excel.Application");
Excel.Workbooks.Open("C:\\Copy of sstD6.xls")
var HeadRow =Excel.ActiveCell.CurrentRegion.ListHeaderRows;
var AllRow = Excel.ActiveCell.CurrentRegion.Rows.Count;
var RowCount = AllRow - HeadRow;
var MyDDTObject = DDT.ExcelDriver("C:\\Copy of sstD6.xls", "TestList", true)
while (Row != RowCount)
{
if (Row == 5)
{ while (Row != RowCount)
{
Log.Message(MyDDTObject.Value(6))
MyDDTObject.Next();
Row++;
}
}
else
{
Row++;
MyDDTObject.Next();
}
}
DDT.CloseDriver(MyDDTObject.Name)
}