Right click on the same Table Pair used to create the empty spreadsheet and select
Generate Tests from Spreadsheet
Using the dialog, click the
button and open the spreadsheet that you just saved.
The tests are imported and displayed in the dialog.
If you import a LOT of tests (e.g. many dozens or hundreds), the import process can take some time (e.g. 30-60 seconds or even longer) as the import process validates each row of the spreadsheet and identifies any errors.
These errors are highlighted in the import dialog with red/yellow icons.
Red icons on the left indicate the test in that row has errors.
Yellow icons on individual cells point out specific cells that require attention.
Correct the errors found during the import. In the image above, the last 2 tests have errors in them that need to be addressed.
You can add and remove tests using this dialog by clicking on the
buttons on the right.
This provides you with additional controls when correcting imported test definitions.
to generate the tests. Inspect the generated tests to verify that tests imported correctly.
Note that all tests imported will be added to the Table Pair, even IF, the Table Pair already contains tests with the same definitions. i.e. duplicate checking is not performed when creating the new tests from the spreadsheet metadata.
Although, this is a very simple example to illustrate how to use the spreadsheet import functionality, the real power of this functionality is when many dozens or hundreds of tests are required, and basic spreadsheet capabilities such as copy/paste or simple string expressions can be used in the spreadsheet to quickly create large numbers of tests.