Write a checks result to an Excel workbook — write_checks

Turns the list returned by a checks_*() function into a single styled .xlsx workbook: a Summary tab listing every applicable check and its flagged-row count, followed by one tab of flagged rows per check that found problems. Sheets get a navy header, sized columns and inferred number formats. No versioning – the file is written straight to path.

Usage

write_checks_excel(checks, path)

Arguments

checks: A list returned by checks_afp() (or any checks_*()), carrying a summary element and zero or more flagged-row tibbles.
path: Output .xlsx path.

Value

path, invisibly.

Examples

if (FALSE) { # \dontrun{
write_checks_excel(checks_afp(afp), "checks_afp.xlsx")
} # }