Test Runner 4 Excel (TR4E)

Test Runner 4 Excel (TR4E) is an Excel Addin that allows users to securely execute test cases from an Excel worksheet against any accessible API. TR4E compares the actual results from calling the API against an expected result in the Excel worksheet, and can calculate the difference based upon discrepancies. Test results are written to a new worksheet in the test case workbook. TR4E uses your SharePoint subscription as it primary portal for loading test case workbooks, and optionally writing request and response payloads.

TR4E can be run without a subscription, but to unlock the key security features and runtime options consider licensing a subscription that can be tailored to your needs. You can request an evaluation subscription from the TR4E Service Desk under "Product trial questions".

The growing TR4E feature list includes:

• MS 365 SharePoint subscription integration to load test cases workbooks, transformers and optionally save request / response payloads
• MS 365 Excel subscription integration to load test case worksheets, write test case result worksheets and update the test case history worksheet
• Azure Entra ID integration supporting seamless single sign on (SSO) for improved security

Once your Microsoft 365 administrator has installed TR4E the following steps will get you up and running:

• Watch the TR4E introduction video here
• Download the "TR4E Virtual Underwriter" example from the introduction video here
• Read the documentation on the product site here