Matt Dray

updated the title to 'whole sheet' from 'whole table', reflecting the possibility of notes in pre-table meta content as well.

I forgot this issue existed and I began toying with the idea of YAML input in a branch of [matt-dray/a11ytables2](https://github.com/matt-dray/a11ytables2). [Example YAML](https://github.com/matt-dray/a11ytables2/blob/md-yaml/inst/extdata/example.yaml) I was using for testing purposes: ``` yaml...

To note: this is something that the gptables team would also like to solve, but is also proving difficult in Python given the limits of the xlsx-related packages being wrapped.

{dftutils} has [a `clean_metadata()` function](https://github.com/department-for-transport-public/dftutils/blob/main/R/clean_metadata.R) that could be useful here; thanks @DIPAD-Fran-Bryden for making me aware of this package.

You can `set_properties` as a method in {openxlsx2}, useful for #70.

{openxlsx2} has continued to develop and is on CRAN, but it's still not a v1. There's [a vignette](https://janmarvin.github.io/openxlsx2/articles/Update-from-openxlsx.html) to explain some of the changes. Consider forking {a11ytables} and creating {a11ytables2}...

A nice accessibility feature that appeared in a test of the package is that automatic cell colour is supported through `wb_color(auto = "1")`. [Demo in a Gist](https://gist.github.com/matt-dray/3910663e0c7cbf499d65ee3a73efcb88).

Hi Stanley, thanks for the message. Yeah, as far as I know, {openxlsx} doesn't really have an analogue for `openxlsx2::wb_set_properties()`, aside from the `addCreator()` and `setLastModifiedBy()` functions. This is definitely...

I think it might be conceptually weird for the user _not_ to provide the contents table, since they'll be providing a table for all the other sheets. I think this...

Better: generate the notes sheet on behalf of the user if they do not provide the information to create one. This would maintain backwards compatibility too.