Write test output as an xlsx workbook, with a specific sheet for each extract. The extract sheet will be dated with the current month and day, which allows us to run the tests multiple times in the same update.
Usage
write_tests_xlsx(
comparison_data,
sheet_name,
year = NULL,
workbook_name = c("ep_file", "indiv_file", "lookup", "extract", "sandpit",
"cross_year")
)
Arguments
- comparison_data
produced by
produce_test_comparison()
- sheet_name
the name of the dataset, which will be used to create the sheet name
- year
If applicable, the financial year of the data in '1920' format this will be prepended to the sheet name. The default is
NULL
.- workbook_name
Split up tests into 4 different workbooks for ease of interpreting. Episode file, individual file, lookup and extract tests.
Value
a tibble containing a test comparison.
See also
produce_test_comparison
Other test functions:
get_existing_data_for_tests()
,
produce_test_comparison()