Integrating UFT 14 with Excel

There are multiple approaches to integrate UFT 14 with Excel to enhance automated testing capabilities. These integrations allow users to interact with Excel spreadsheets directly from UFT, enabling data-driven testing and other functionalities. Below, we will outline the key ways to perform this integration effectively.

Updating UFT 14 to the Required Patch Level

Before integrating UFT 14 with Excel, it is essential to ensure that you have updated UFT to the correct patch level. Excel integration requires at least UFT 14.03 patch 3, and for more recent versions, UFT 14.53 patch 4 or later is necessary. Without these patches, the integration may not function correctly or could be entirely unsupported.

Running Functions to Load Data from Excel

To load data from an Excel spreadsheet, you can write a function in UFT 14 that builds an array of Excel sheet names. This is achieved by looping through each sheet in the Excel file and adding them to the array using a For loop. However, ensure that this function is compatible with the version of UFT you are using to avoid errors, such as the general error thrown when this function is run in UFT 15.

Avoiding Headless Mode for Excel Integration

When integrating UFT 14 with Excel, it's important to note that Excel integration is not supported with headless mode. Running UFT in a headless environment will prevent Excel-related functionalities from executing correctly. Therefore, it is crucial to run UFT in a mode that supports GUI interactions with Excel.

Integrating UFT 14 with Sourcetable

Integrating UFT (Unified Functional Testing) 14 with Sourcetable offers several significant benefits over using traditional spreadsheets like Excel for test data management. With Sourcetable, you can sync live data from a variety of apps or databases, which allows for real-time data retrieval during testing. This ensures that test cases always use the most current and relevant data, enhancing the accuracy of test results.

Another advantage of using Sourcetable is the ease of automation. Sourcetable's ability to pull data from multiple sources without manual intervention saves time and reduces the risk of errors associated with manual data entry. Consequently, test execution becomes more efficient and reliable. Additionally, the familiar spreadsheet interface of Sourcetable simplifies querying and manipulating data, making it accessible even for those with basic spreadsheet knowledge.

Finally, Sourcetable is an excellent tool for business intelligence within the context of UFT 14 testing. It provides a centralized platform for aggregating test data, which can then be analyzed to gain insights into application behavior and performance. This can inform strategic decisions and improve the overall quality of the software development lifecycle.

Common Use Cases

• U

  
  Reading cell values one by one for all columns in an Excel file
• U

  
  Reading cell values one by one for all rows in an Excel file
• U

  
  Retrieving data from a specific cell using GetExcelCellData
• U

  
  Writing data to a specific cell using SetExcelCellData
• U

  
  Counting the number of sheets in an Excel file using GetExcelSheetCount

Frequently Asked Questions

How does UFT 14 load data from an Excel spreadsheet?

UFT 14 loads data from an Excel spreadsheet by using DataTable.GetSheet function which retrieves the sheets. It builds an array of sheet names as it loops through multiple worksheets.

What happens if DataTable.GetSheet fails to get a sheet?

If DataTable.GetSheet fails to get a sheet, indicated by the error code ERR_NO_PARAMETER or -2147220908, the code will then add the sheet.

Can UFT 14 handle multiple worksheets within a single Excel spreadsheet?

Yes, UFT 14 can handle multiple worksheets within a single Excel spreadsheet. It uses a function that loops through the sheets and builds an array of sheet names.

What is the significance of Excel integration with UFT 14?

Excel integration with UFT 14 is significant for data-driven testing, which involves using Excel for storing both the test data and test results.

What is a common error code associated with DataTable.GetSheet, and what does it mean?

The common error code associated with DataTable.GetSheet is -2147220908, which means ERR_NO_PARAMETER, indicating that DataTable.GetSheet failed to retrieve the sheet.