+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Want to read the data from excel and set read value in the JavaTable (/Thread-Want-to-read-the-data-from-excel-and-set-read-value-in-the-JavaTable)
Want to read the data from excel and set read value in the JavaTable - rajeevk7 - 07-10-2017
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.