REQ - Recommended packages for Excel

[Moohan]

https://github.com/Public-Health-Scotland/technical-docs/blob/7bfaa04e28cc9bdeba61f1b181f99c463e8544e4/R/Recommended%20R%20Packages.md?plain=1#LL15

The current recommendation openxlsx has lots of great features but really isn't the easiest to use, not least because the functions are quite inconsistent and the documentation is sometimes misleading.

I think better recommendations would be readxl for reading Excel files a writexl for writing. These are both much smaller, simpler packages and part of well respected ecosystems (tidyverse and R Open Sci) respectively.

I would only recommend using openxl when wanting to format the output. I think it's worth keeping an eye one openxlsx2 which isn't currently stable but aims to replicate the functionality but using programming flows like pipes - which would obviously fit much better with the PHS code style (tidyverse).