How to read data from excel sheet in uft
UFT provides inbuilt capability to manage and use test data with the help of two sheets namely Global and local datasheet. We can also use external data sheet or excel sheet as a test data file in uft by importing it into the in built datatable. UFT provides many methods to manipulate the data or read / write data.
In order to read and write data in an external file, first we need to import the data sheet into either one of the in built data sheets i.e. Global or local. Then we can access the values of excel file.
This page has example code to read data from excel using UFT DataTable methods which helps in reading data from external excel workbook using UFT.