Excel Test Repository Integration

Excel Test Repository integration allows an Excel spreadsheet containing test assets like the following to be searched for a supplied set of tokens.

Excel test assets.

Architecture

LiveCompare uses ODBC to connect to an Excel spreadsheet registered as an External Data Source.

Excel integration architecture.

Requirements

LiveCompare requires the following in order to connect to Excel.

  • Access to an Excel spreadsheet registered as an External Data Source.
  • A Test Repository in which to store test hit results (for example, a Tosca or qTest Test Repository).
  • A custom workflow to populate the Test Repository cache using the Write Test Repository Cache action.

Issues

  • Excel spreadsheets that store test assets may not have a standard format.

  • The Excel worksheet must first be registered as an External Data Source. This can be verified using ‘Show Sample Data’’.​

  • The wrong External Data Source may have been chosen.​

  • If testing on the LiveCompare server, make sure that the Excel file is not open, as this will lock it and prevent LiveCompare from accessing the file.

Searching Excel Test Repositories

Searching an Excel spreadsheet requires the following to be specified:

  • TableName: The name of the Excel spreadsheet.
  • TestCaseIdIndex: A zero-based column index that identifies a unique test case ID.
  • TestCaseNameIndex: A zero-based column index that identifies the test case name.
  • SearchIndices: A string list of zero-based column indices to search for tokens.

Test Repository Integrations