Want to read the data from excel and set read value in the JavaTable

[rajeevk7]

Hi all,

I tried to  read the the value from the excel and add the value in the java table below is the code

 
datatable.Import "C:\Users\rajeevk7\Downloads\data.xls"
a=datatable.GetRowCount()
For i= 1 to a
datatable.SetCurrentRow(i)
JavaWindow("42_Head - Cisco Transport_2").JavaDialog("New Profile").JavaEdit("New Profile Name:").Set datatable.Value(1,1)
JavaWindow("42_Head - Cisco Transport_2").JavaDialog("New Profile").JavaButton("OK").Click
JavaWindow("CTC").JavaTable("AlarmProfileTable").selectSelectcell("#25","Node80").set datatable.Value(2,1)

I want to add the value from the \data.xls on the java table -- alaram Profile.

Please help me.