{"Package":"xlr","Title":"Create Table Summaries and Export Neat Tables to 'Excel'","Version":"1.0.3","Authors@R":"person(given = \"Nicholas\",\nfamily = \"Hilderson\",\nrole = c(\"aut\", \"cre\", \"cph\"),\nemail = \"nhilderson.code@gmail.com\"\n)","Description":"A high-level interface for creating and exporting summary tables to\n'Excel'. Built on 'dplyr' and 'openxlsx', it provides tools for generating\none-way to n-way tables, and summarizing multiple response questions\nand question blocks. Tables are exported with native 'Excel' formatting,\nincluding titles, footnotes, and basic styling options.","License":"GPL (>= 3)","Encoding":"UTF-8","RoxygenNote":"7.3.2","Collate":"as_base_r.R xlr_table.R xlr_to_workbook.R\nbuild_multiple_response_table.R build_table.R write_xlsx.R\nxlr_numeric.R xlr_integer.R xlr_vector.R xlr_percent.R\nxlr_format.R openxlsx_utils.R xlr_doc.R error_utils.R\ncreate_table_of_contents.R build_question_block_table.R\ntable_utils.R data.R is_xlr_type.R","Suggests":"knitr, rmarkdown, testthat (>= 3.0.0), data.table, lubridate","Config/testthat/edition":"3","Imports":"rlang, vctrs (>= 0.6.0), haven, openxlsx, methods, cli, dplyr,\ntibble, pillar, tidyr, tidyselect","Depends":"R (>= 4.1.0)","LazyData":"true","VignetteBuilder":"knitr","URL":"https://nhilder.github.io/xlr/, https://github.com/NHilder/xlr","BugReports":"https://github.com/NHilder/xlr/issues","NeedsCompilation":"no","Packaged":"2025-03-05 21:40:22 UTC; nicholashilderson","Author":"Nicholas Hilderson [aut, cre, cph]","Maintainer":"Nicholas Hilderson ","Repository":"CRAN","Date/Publication":"2025-03-07 11:40:02 UTC","repoType":"cran","tarballUrl":"ftp://cran.r-project.org/pub/R/src/contrib/xlr_1.0.3.tar.gz","jsonAuthors":[{"name":"Nicholas Hilderson","email":"nhilderson.code@gmail.com","maintainer":true}],"readme":"\n\n\n# xlr or ‘Exceller’\n\n\n\n[![R-CMD-check](https://github.com/NHilder/xlr/actions/workflows/R-CMD-check.yaml/badge.svg)](https://github.com/NHilder/xlr/actions/workflows/R-CMD-check.yaml)\n\n\n# xlr\n\nxlr is designed to help build summary tables with complex survey data,\nand export data to `Excel`. It includes functions to easily make\ncross-tabulations, work with multiple response data, and question\nblocks. It supports labelled data that can be generated from the popular\nsurvey platform Qualtrics.\n\nIt makes exporting data from `Excel` easier. It is a easier to use wrapper\naround [openxlsx](https://ycphs.github.io/openxlsx/). It supports tables\nwith footnotes, headers, and generating table of contents in `Excel`\ndocuments. It is not fully featured, but designed to be used when you\nare moving either statistical summaries or tables from R into `Excel`.\n\nThis package is designed to work seamlessly with\n[tidyverse](https://www.tidyverse.org/) family of functions.\n\nIt is currently experimental and subject to change based on peoples\nfeedback.\n\n## Installation\n\n``` r\n# To install via CRAN\ninstall.packages(\"xlr\")\n```\n\nYou can install the development version of xlr from\n[GitHub](https://github.com/) with:\n\n``` r\n# install.packages(\"pak\")\npak::pak(\"NHilder/xlr\")\n```\n\n## Example\n\nThis is a example of how to create a two-way table, fix the formatting\nfor that table, and then export that table to `Excel`.\n\n``` r\nlibrary(xlr)\nlibrary(dplyr)\n#> \n#> Attaching package: 'dplyr'\n#> The following objects are masked from 'package:stats':\n#> \n#> filter, lag\n#> The following objects are masked from 'package:base':\n#> \n#> intersect, setdiff, setequal, union\n\n# create a summary table\ntwo_way_table <- build_table(mtcars,c(cyl,gear))\ntwo_way_table\n#> # A xlr_table: 8 x 4\n#> cyl gear N Percent\n#> \n#> 1 4.00 3.00 1 9%\n#> 2 4.00 4.00 8 73%\n#> 3 4.00 5.00 2 18%\n#> 4 6.00 3.00 2 29%\n#> 5 6.00 4.00 4 57%\n#> 6 6.00 5.00 1 14%\n#> 7 8.00 3.00 12 86%\n#> 8 8.00 5.00 2 14%\n\n# make the percentage have two decimal places using dplyr\ntwo_way_table <- two_way_table |> \n mutate(Percent = xlr_percent(Percent, dp = 2))\n\n# write the data to an xlsx file\nwrite_xlsx(two_way_table,\n \"example.xlsx\",\n \"an example\")\n#> ℹ Appending file: 'example.xlsx'\n```\n\nCheck out the vignettes for more information on how to use the package.","jobInfo":{"package":"xlr","version":"1.0.3","parsingStatus":"success","parserVersion":2,"parsedAt":"2025-03-07T13:30:05+0000"}}

Description

Arguments