Feature request: automated analysis "tables" in Excel

[martinctc]

Here is an idea inspired by market research practices....

For survey analysis, traditionally people run "tables", which is like 50 odd pages of data tables that have all the means, medians, % of contingency pre-run for an entire questionnaire. It's basically like sufficient to do a substantial piece of analysis on it. It's great for very fast data exploration for analysts and detail-oriented customers, even though it's not necessarily something busy stakeholders would want.

I was thinking whether we can re-produce something similar with the R package - i.e. an Excel workbook output with one sheet per table. Almost like a keymetrics_scan() per value per org. It's overwhelming and is almost like appendix material, but you almost just run it once and barely have to look back again the analysis.

We may require a writexl dependency or suggests. For naming, we can discuss but a starting point could be: keymetrics_tables().

[martinctc]

For exporting as Excel tables, an alternative idea is to enable export() to export Excel tables when the input is a list of data frames. Therefore, a flow could be:

sq_data %>%
  keymetrics_table() %>% # Returns a named list of data frames, names = Excel Sheetnames
  export(method = "excel") # Requires {writexl} installed, saves an Excel file to path

[moralec]

In the past I have used the Library openxlsx. It allows to write excel and different tabs: Options include: addWorksheet() saveWorkbook()

[martinctc]

Was thinking writexl to be consistent with tidyverse. I understand both options are dependency free, so either could work.