In this tutorial, we will be working with Excel with Micro Focus UFT
Consider we want to import the following Sales.xls
Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, PHP, Python, Bootstrap, Java and XML.
Once imported into HP UFT, the top row becomes the column header. So structure your data accordingly.
The Syntax to import entire Excel file is
In our case
The Syntax to import a particular sheet is
Use the method Getrowcount to get number of rows in the sheet
To set the current row to use the method SetCurrentRow
' In the code below, 1 is the sheet number
Use the Value method to change data in the imported sheet. Use the Export method to export the Excel