Excel Test Repository integration

Excel Test Repository integration allows you to search an Excel spreadsheet to find test assets that match 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 Test Repository integration architecture.

Requirements

LiveCompare requires the following in order to connect to Excel.

  • Access to an Excel spreadsheet containing exported Jira data, which is registered as an External Data Source.

  • An Excel Test Repository in which to store test hit results.

Issues

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

  • You must first register the Excel worksheet as an External Data Source. You can verify this using Show Sample Data.

  • You may have chosen the wrong External Data Source.

  • 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.

Search Excel Test Repositories

You will need to specify the following when searching an Excel Test Repository.

  • 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.

Related topics

Test Repository integrations