{
  "_id": "6a1413caacfb0bcc41d3bc85",
  "Package": "xlr",
  "Title": "Create Table Summaries and Export Neat Tables to 'Excel'",
  "Version": "1.1.2.9000",
  "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\ntables to 'Excel'. Built on 'dplyr' and 'openxlsx', it provides\ntools for generating one-way to n-way tables, and summarizing\nmultiple response questions and question blocks. Tables are\nexported with native 'Excel' formatting, including titles,\nfootnotes, and basic styling options.",
  "License": "GPL (>= 3)",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.3",
  "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_n_percent.R xlr_format.R openxlsx_utils.R xlr_doc.R\nerror_utils.R create_table_of_contents.R\nbuild_question_block_table.R table_utils.R data.R is_xlr_type.R\nmake_wider.R remove_NA.R",
  "Config/testthat/edition": "3",
  "LazyData": "true",
  "VignetteBuilder": "knitr",
  "URL": "https://nhilder.github.io/xlr/, https://github.com/NHilder/xlr",
  "BugReports": "https://github.com/NHilder/xlr/issues",
  "Config/pak/sysreqs": "make libicu-dev libx11-dev zlib1g-dev",
  "Repository": "https://nhilder.r-universe.dev",
  "Date/Publication": "2026-02-24 05:58:42 UTC",
  "RemoteUrl": "https://github.com/nhilder/xlr",
  "RemoteRef": "HEAD",
  "RemoteSha": "e5badc669344103f69e5834e24fddcadd6c926ca",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-25 09:14:22 UTC",
    "User": "root"
  },
  "Author": "Nicholas Hilderson [aut, cre, cph]",
  "Maintainer": "Nicholas Hilderson <nhilderson.code@gmail.com>",
  "MD5sum": "c8b6f05121a84995a7f460d0c0d2fc73",
  "_user": "nhilder",
  "_type": "src",
  "_file": "xlr_1.1.2.9000.tar.gz",
  "_fileid": "abf0e62eaed656d5089f1e92254b14ba175b2a7534f06587c8de968706fab1b0",
  "_filesize": 894059,
  "_sha256": "abf0e62eaed656d5089f1e92254b14ba175b2a7534f06587c8de968706fab1b0",
  "_created": "2026-05-25T09:14:22.000Z",
  "_published": "2026-05-25T09:18:02.558Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77686766294,
      "time": 172,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7195316348"
    },
    {
      "job": 77686766322,
      "time": 172,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7195316437"
    },
    {
      "job": 77686766304,
      "time": 167,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7195307763"
    },
    {
      "job": 77686766308,
      "time": 157,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7195305040"
    },
    {
      "job": 77686297950,
      "time": 195,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7195272185"
    },
    {
      "job": 77686766297,
      "time": 118,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7195303048"
    },
    {
      "job": 77686766329,
      "time": 178,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7195317883"
    },
    {
      "job": 77686766344,
      "time": 140,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7195308740"
    },
    {
      "job": 77686766320,
      "time": 127,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7195305198"
    }
  ],
  "_buildurl": "https://github.com/r-universe/nhilder/actions/runs/26392789794",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/nhilder/xlr",
  "_commit": {
    "id": "e5badc669344103f69e5834e24fddcadd6c926ca",
    "author": "Nicholas Hilderson <108131229+NHilder@users.noreply.github.com>",
    "committer": "Nicholas Hilderson <108131229+NHilder@users.noreply.github.com>",
    "message": "Increment version number to 1.1.2.9000\n",
    "time": 1771912722
  },
  "_maintainer": {
    "name": "Nicholas Hilderson",
    "email": "nhilderson.code@gmail.com",
    "login": "nhilder",
    "description": "",
    "uuid": 108131229
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "vctrs",
      "version": ">= 0.6.0",
      "role": "Imports"
    },
    {
      "package": "haven",
      "role": "Imports"
    },
    {
      "package": "openxlsx",
      "role": "Imports"
    },
    {
      "package": "methods",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "pillar",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "tidyselect",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "version": ">= 3.0.0",
      "role": "Suggests"
    },
    {
      "package": "data.table",
      "role": "Suggests"
    },
    {
      "package": "lubridate",
      "role": "Suggests"
    },
    {
      "package": "ggplot2",
      "role": "Suggests"
    }
  ],
  "_owner": "nhilder",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-37",
      "n": 2
    },
    {
      "week": "2025-41",
      "n": 4
    },
    {
      "week": "2025-48",
      "n": 5
    },
    {
      "week": "2025-50",
      "n": 1
    },
    {
      "week": "2026-01",
      "n": 4
    },
    {
      "week": "2026-03",
      "n": 9
    },
    {
      "week": "2026-04",
      "n": 2
    },
    {
      "week": "2026-08",
      "n": 2
    },
    {
      "week": "2026-09",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v1.1.0",
      "date": "2026-01-14"
    },
    {
      "name": "v1.1.1",
      "date": "2026-01-16"
    },
    {
      "name": "v1.1.2",
      "date": "2026-02-20"
    }
  ],
  "_stars": 4,
  "_contributors": [
    {
      "user": "nhilder",
      "count": 77,
      "uuid": 108131229
    },
    {
      "user": "davisvaughan",
      "count": 1,
      "uuid": 19150088
    }
  ],
  "_userbio": {
    "uuid": 108131229,
    "type": "user",
    "name": "Nicholas Hilderson"
  },
  "_downloads": {
    "count": 231,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/xlr"
  },
  "_devurl": "https://github.com/nhilder/xlr",
  "_pkgdown": "https://nhilder.github.io/xlr/",
  "_searchresults": 4,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/xlr.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/nhilder/xlr",
  "_realowner": "nhilder",
  "_cranurl": true,
  "_releases": [
    {
      "version": "1.0.3",
      "date": "2025-03-07"
    },
    {
      "version": "1.1.0",
      "date": "2026-01-14"
    },
    {
      "version": "1.1.1",
      "date": "2026-01-17"
    },
    {
      "version": "1.1.2",
      "date": "2026-02-21"
    }
  ],
  "_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"
  ],
  "_datasets": [
    {
      "name": "clothes_opinions",
      "title": "Clothes opinions data",
      "object": "clothes_opinions",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "weight",
        "group",
        "gender",
        "gender2",
        "age",
        "age_group",
        "Q1_1",
        "Q1_2",
        "Q1_3",
        "Q1_4",
        "Q2_1",
        "Q2_2",
        "Q2_3",
        "Q2_4",
        "Q2_5",
        "Q2_6",
        "Q3_1",
        "Q3_2",
        "Q3_3",
        "Q3_other"
      ],
      "rows": 1000,
      "table": true,
      "tojson": false
    }
  ],
  "_help": [
    {
      "page": "as_base_r",
      "title": "Convert xlr types to their base R type",
      "topics": [
        "as_base_r"
      ]
    },
    {
      "page": "build_mtable",
      "title": "Summarise a multiple response table",
      "topics": [
        "build_mtable"
      ]
    },
    {
      "page": "build_qtable",
      "title": "Summarize a Question Block",
      "topics": [
        "build_qtable"
      ]
    },
    {
      "page": "build_table",
      "title": "Create a one, two, three,..., n-way table",
      "topics": [
        "build_table"
      ]
    },
    {
      "page": "clothes_opinions",
      "title": "Clothes opinions data",
      "topics": [
        "clothes_opinions"
      ]
    },
    {
      "page": "create_table_of_contents",
      "title": "Adds a table of contents to an .xlsx ('Excel') file",
      "topics": [
        "create_table_of_contents"
      ]
    },
    {
      "page": "is_xlr_format",
      "title": "Test if an object is a 'xlr_format'",
      "topics": [
        "is_xlr_format"
      ]
    },
    {
      "page": "is_xlr_type",
      "title": "Check if a variable is an xlr type This function tests whether an R variable has a xlr type.",
      "topics": [
        "is_xlr_type"
      ]
    },
    {
      "page": "make_wider",
      "title": "Pivot a table wider combining counts and percentages",
      "topics": [
        "make_wider"
      ]
    },
    {
      "page": "update_theme",
      "title": "Update the 'xlr_table' theme",
      "topics": [
        "update_theme"
      ]
    },
    {
      "page": "write_xlsx",
      "title": "Write a 'xlr_table', 'data.frame', or 'tibble' to an .xlsx ('Excel') file",
      "topics": [
        "write_xlsx"
      ]
    },
    {
      "page": "xlr_and_dplyr",
      "title": "xlr and dplyr",
      "topics": [
        "xlr_and_dplyr"
      ]
    },
    {
      "page": "xlr_format",
      "title": "Specify formatting options for xlr_* types",
      "topics": [
        "xlr_format",
        "xlr_format_numeric"
      ]
    },
    {
      "page": "xlr_integer",
      "title": "'xlr_integer' vector",
      "topics": [
        "as_xlr_integer",
        "is_xlr_integer",
        "xlr_integer"
      ]
    },
    {
      "page": "xlr_n_percent",
      "title": "'xlr_n_percent' vector",
      "topics": [
        "is_xlr_n_percent",
        "xlr_n_percent"
      ]
    },
    {
      "page": "xlr_numeric",
      "title": "'xlr_numeric' vector",
      "topics": [
        "as_xlr_numeric",
        "is_xlr_numeric",
        "xlr_numeric"
      ]
    },
    {
      "page": "xlr_percent",
      "title": "'xlr_percent' vector",
      "topics": [
        "as_xlr_percent",
        "is_xlr_percent",
        "xlr_percent"
      ]
    },
    {
      "page": "xlr_table",
      "title": "'xlr_table' object",
      "topics": [
        "as_xlr_table",
        "is_xlr_table",
        "xlr_table"
      ]
    },
    {
      "page": "xlr_vector",
      "title": "'xlr_vector' vector",
      "topics": [
        "as_xlr_vector",
        "is_xlr_vector",
        "xlr_vector"
      ]
    }
  ],
  "_readme": "https://github.com/nhilder/xlr/raw/HEAD/README.md",
  "_rundeps": [
    "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"
  ],
  "_vignettes": [
    {
      "source": "xlr.Rmd",
      "filename": "xlr.html",
      "title": "Getting started with xlr",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Data: clothes_opinions",
        "Analysing survey data",
        "build_table()",
        "Introduction to xlr_table()",
        "Labels in xlr",
        "Weights",
        "Missing data",
        "build_mtable()",
        "Multiple multiple response columns",
        "build_qtable()",
        "xlr_table(), xlr types and writing to Excel",
        "Types",
        "Updating/Formatting columns",
        "dplyr verbs",
        "Writing data to Excel",
        "write_xlsx() and list()",
        "Putting it all together"
      ],
      "created": "2025-02-23 05:59:40",
      "modified": "2026-01-14 04:57:23",
      "commits": 3
    }
  ],
  "_score": 5.2552725051033065,
  "_indexed": true,
  "_nocasepkg": "xlr",
  "_universes": [
    "nhilder"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.1.2.9000",
      "date": "2026-05-25T09:16:40.000Z",
      "distro": "noble",
      "commit": "e5badc669344103f69e5834e24fddcadd6c926ca",
      "fileid": "fd54b086eb8c864e74f2bffc5b22025a80a545046736211477120816a1ce840d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nhilder/actions/runs/26392789794"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.1.2.9000",
      "date": "2026-05-25T09:16:40.000Z",
      "distro": "noble",
      "commit": "e5badc669344103f69e5834e24fddcadd6c926ca",
      "fileid": "7127c6a884bc632ce53e62aea85c54b66edbc5523ac5e0c9694969f60079acf0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nhilder/actions/runs/26392789794"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.1.2.9000",
      "date": "2026-05-25T09:16:25.000Z",
      "commit": "e5badc669344103f69e5834e24fddcadd6c926ca",
      "fileid": "8d80f93f188b9ac26197d435cb2c840c08a491afd0d651bdc7189ccb30eac227",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nhilder/actions/runs/26392789794"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "1.1.2.9000",
      "date": "2026-05-25T09:16:13.000Z",
      "commit": "e5badc669344103f69e5834e24fddcadd6c926ca",
      "fileid": "e94ebd75178669a587c8b2ddfa056e3ae22b171db9c7e71aea4b25d3229dcc52",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nhilder/actions/runs/26392789794"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.1.2.9000",
      "date": "2026-05-25T09:16:39.000Z",
      "commit": "e5badc669344103f69e5834e24fddcadd6c926ca",
      "fileid": "e05396a593499fe4af0261aa6eb8dea3e17df8d46ad3347bc253b176c255253e",
      "status": "success",
      "buildurl": "https://github.com/r-universe/nhilder/actions/runs/26392789794"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.1.2.9000",
      "date": "2026-05-25T09:16:31.000Z",
      "commit": "e5badc669344103f69e5834e24fddcadd6c926ca",
      "fileid": "a94f3d0bcc0df56eebac3704ff6590f5c5675dc12793400c344ac0ee8886bddd",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nhilder/actions/runs/26392789794"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.1.2.9000",
      "date": "2026-05-25T09:15:51.000Z",
      "commit": "e5badc669344103f69e5834e24fddcadd6c926ca",
      "fileid": "fea2ce3e5100e6a54b656502972d73d22b4a07f6cfa37b52c9cbe8c860ea0301",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nhilder/actions/runs/26392789794"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "1.1.2.9000",
      "date": "2026-05-25T09:15:43.000Z",
      "commit": "e5badc669344103f69e5834e24fddcadd6c926ca",
      "fileid": "7a74bb867427e2b846fe612fa472e1d7e5d78c0abb1f7cd8964c11b2bd99a104",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/nhilder/actions/runs/26392789794"
    }
  ]
}