Writing to Run time data table

[ADITI1992]

Hi Neetha,
1>

Code:

Set xl = createobject("Excel.Application")
xl.Application.Visible = true
Set workbook = xl.Workbooks.Open ("C:\Desktop\KED.xls")
Set sheet = Workbook.worksheets ("TESTCASE")
row = sheet.usedrange.rows.count
col = sheet.usedrange.columns.count
For i=1 to row
    For j=1 to col
a=sheet.cells(i,j).value    'place here the row name so that when it enters the loop u will be able to see for which row the code is working presently
    Next
Next
xl.Quit
Set xl = nothing

2> take the output in a variable then set in specific cell.
---------suppose output comes in variable b then

Code:

sheet.cells(k,h).value =b

' also if u want output in runtime datatable then you can add a sheet in the beginning (datatable.add) and write value in it during runtime.
'u can employ print/msgbox keywords to display the output value too.