Package: xlr 1.1.2.9000

xlr: Create Table Summaries and Export Neat Tables to 'Excel'

A high-level interface for creating and exporting summary tables to 'Excel'. Built on 'dplyr' and 'openxlsx', it provides tools for generating one-way to n-way tables, and summarizing multiple response questions and question blocks. Tables are exported with native 'Excel' formatting, including titles, footnotes, and basic styling options.

Authors:Nicholas Hilderson [aut, cre, cph]

xlr_1.1.2.9000.tar.gz
xlr_1.1.2.9000.zip(r-4.7-any)xlr_1.1.2.9000.zip(r-4.6-any)xlr_1.1.2.9000.zip(r-4.5-any)
xlr_1.1.2.9000.tgz(r-4.6-any)xlr_1.1.2.9000.tgz(r-4.5-any)
xlr_1.1.2.9000.tar.gz(r-4.7-any)xlr_1.1.2.9000.tar.gz(r-4.6-any)
xlr_1.1.2.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
xlr/json (API)

# Install 'xlr' in R:

install.packages('xlr', repos = c('https://nhilder.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/nhilder/xlr/issues

Pkgdown/docs site:https://nhilder.github.io

Datasets:

clothes_opinions - Clothes opinions data

On CRAN:

5.26 score 4 stars 4 scripts 288 downloads 29 exports 35 dependencies

Last updated from:e5badc6693. Checks:9 OK. Indexed: yes.

Target	Result	Time
linux-devel-x86_64	OK	190
source / vignettes	OK	221
linux-release-x86_64	OK	182
macos-release-arm64	OK	115
macos-oldrel-arm64	OK	144
windows-devel	OK	121
windows-release	OK	122
windows-oldrel	OK	159
wasm-release	OK	141

Exports:as_base_r as_xlr_integer as_xlr_numeric as_xlr_percent as_xlr_table as_xlr_vector build_mtable build_qtable build_table create_table_of_contents is_xlr_format is_xlr_integer is_xlr_n_percent is_xlr_numeric is_xlr_percent is_xlr_table is_xlr_type is_xlr_vector make_wider update_theme write_xlsx xlr_format xlr_format_numeric xlr_integer xlr_n_percent xlr_numeric xlr_percent xlr_table xlr_vector

Dependencies:bit bit64 cli clipr cpp11 crayon dplyr forcats generics glue haven hms lifecycle magrittr openxlsx pillar pkgconfig prettyunits progress purrr R6 Rcpp readr rlang stringi stringr tibble tidyr tidyselect tzdb utf8 vctrs vroom withr zip

Getting started with xlr

Rendered fromxlr.Rmdusingknitr::rmarkdown

Last update: 2026-01-14
Started: 2025-02-23

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Convert xlr types to their base R type	as_base_r
Summarise a multiple response table	build_mtable
Summarize a Question Block	build_qtable
Create a one, two, three,..., n-way table	build_table
Clothes opinions data	clothes_opinions
Adds a table of contents to an .xlsx ('Excel') file	create_table_of_contents
Test if an object is a 'xlr_format'	is_xlr_format
Check if a variable is an xlr type This function tests whether an R variable has a xlr type.	is_xlr_type
Pivot a table wider combining counts and percentages	make_wider
Update the 'xlr_table' theme	update_theme
Write a 'xlr_table', 'data.frame', or 'tibble' to an .xlsx ('Excel') file	write_xlsx
xlr and dplyr	xlr_and_dplyr
Specify formatting options for xlr_* types	xlr_format xlr_format_numeric
'xlr_integer' vector	as_xlr_integer is_xlr_integer xlr_integer
'xlr_n_percent' vector	is_xlr_n_percent xlr_n_percent
'xlr_numeric' vector	as_xlr_numeric is_xlr_numeric xlr_numeric
'xlr_percent' vector	as_xlr_percent is_xlr_percent xlr_percent
'xlr_table' object	as_xlr_table is_xlr_table xlr_table
'xlr_vector' vector	as_xlr_vector is_xlr_vector xlr_vector