R Observatory: Metrics for openxlsx2 version 1.28

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

openxlsx2

1.28

Read, Write and Edit 'xlsx' Files

31packages depend

161.1Kdownloads / year

87.4%test coverage

7/13checks pass

Overview

About

Maintained by Jan Marvin GarbuszusFirst published 2022-09-3041 releasesCRAN page ↗GitHub ↗

Simplifies the creation of 'xlsx' files by providing a high level interface to writing, styling and editing worksheets.

Install

R (CRAN)pak (dev)Ubuntu (r2u)Fedora (COPR)openSUSE (OBS)

install.packages("openxlsx2", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("JanMarvin/openxlsx2")

Development version from JanMarvin/openxlsx2. Installs pak first if it is not already available.

Release

# enable cranapt (r2u) if it is not already set up, then install
grep -rqs r2u.stat.illinois.edu /etc/apt/sources.list /etc/apt/sources.list.d/ \
  || curl -fsSL https://raw.githubusercontent.com/eddelbuettel/r2u/master/inst/scripts/add_cranapt_noble.sh | sudo bash
sudo apt install -y r-cran-openxlsx2

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled.

bspm (used by r2u) also needs make: sudo apt install make

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-openxlsx2

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

# add the autoCRAN OBS repo (Tumbleweed) if it is missing, then install
zypper -q lr | grep -qi autoCRAN \
  || sudo zypper addrepo https://download.opensuse.org/repositories/devel:/languages:/R:/autoCRAN/openSUSE_Tumbleweed/devel:languages:R:autoCRAN.repo
sudo zypper install -y R-openxlsx2

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed).

Health

CRAN checks

1ERROR5NOTE7OK

Failing flavors

NOTE r-devel-linux-x86_64-debian-clang
NOTE r-devel-linux-x86_64-debian-gcc
NOTE r-devel-linux-x86_64-fedora-clang
NOTE r-devel-linux-x86_64-fedora-gcc
NOTE r-devel-windows-x86_64
ERROR r-patched-linux-x86_64

Slowest check: 11.4 min · r-oldrel-windows-x86_64

Code health

Yes

Tests · ratio 0.53

87.4%

Coverage · measured lines

100%

Documentation · exports

5

Dependencies · direct

Check history

ERROR2026-08-13
7 OK · 5 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
NOTE2026-07-16
11 OK · 2 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
OK2026-07-03
13 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-04-18
10 OK · 3 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
NOTE2026-04-15
10 OK · 4 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE

Show 3 earlier snapshots

ERROR2026-04-14
9 OK · 4 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE
NOTE2026-03-11
11 OK · 3 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE
ERROR2026-03-10
10 OK · 2 NOTE · 0 WARNING · 2 ERROR · 0 FAILURE

Documentation

READMEYes · 485 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 100% structuredCode of conductNoContributing guideNo

Examples that run: 98%
Documented parameters: 88%
Return-value docs: 50%
References docs: 0%

Downloads

161.1K

CRAN downloads in the past year

Rank #982 · ~441/day · ~13.4K/mo

Releases R versions

Daily download trend is not available in this view yet.

12.8K30 days

43.1K90 days

161.1K1 year

Compare downloads with other packages →

Also on3.3K r2u19 autocran11.2K conda_forge

Repository

GitHub ↗ janmarvin/openxlsx2

196Stars

26Forks

23Open issues

3Open PRs

43Releases

3,938Commits

52Contributors

rr-packagexlsx

3,938 commits · Last activity 2026-08-13 · -0.5% stars, 30d

Stars over time

2025-08-02 · 1562026-07-29 · 196

Repository practices

Upstream repositoryBeta

7 development-tooling and community-health practices detected across 5 families in the upstream repository

Checks run against github.com/janmarvin/openxlsx2 on 2026-08-16.

Continuous integration (1)

GitHub Actions

Docs source (1)

README.Rmd

Lint, format, editor (2)

lintrRStudio project

Coverage (2)

Codecov.covrignore

Show all practices

Governance and community (1)

Issue templates

How this is detected·Detection ruleset v1 (2026-07-18)

Dependencies

Declared dependencies

13 external dependencies (excludes base and recommended)

Depends (1)

R >= 3.5.0

Imports (5)

R6 RcppgrDevicesstringiutils

LinkingTo (1)

Rcpp

Suggests (9)

encharter ggplot2 knitr mschart openssl rmarkdown rvg testthat zip

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

31direct

0indirect

Code & Tests

People & History

People (5)

Maintainer (1)

Jan Marvin Garbuszus

Author, Maintainer

Authors (2)

Jan Marvin Garbuszus

Author, Maintainer

Jordan Mark Barbone

Author

Contributors (2)

Arseny Kapoulkine

Contributor, Copyright holder

Olivier Roy

Contributor · added in 1.9

Copyright holders (2)

Arseny Kapoulkine

Contributor, Copyright holder

openxlsx authors

Copyright holder

Listed in earlier versions (1)

Oliver Roy

no longer listed · 1.0 to 1.8

Package Timeline

41 releases. Pick two to compare their code metrics. R releases are shown for context.

1.28Latest
2026-07-03 · current release · diff ↗
1.27
2026-05-25 · diff ↗
R
R 4.6.0 released · 2026-04-24
1.26
2026-04-17 · diff ↗
1.25
2026-03-07 · diff ↗
1.24
2026-02-21 · diff ↗
1.23.1
2026-01-19 · diff ↗
1.23
2026-01-16 · diff ↗
1.22
2025-12-07 · diff ↗
1.21
2025-10-31 · diff ↗
1.20
2025-09-29 · diff ↗
1.19
2025-08-25 · diff ↗
1.18
2025-07-29 · diff ↗
1.17
2025-07-04 · diff ↗
1.16
2025-06-06 · diff ↗
1.15
2025-04-25 · diff ↗

Show 30 earlier events

R
R 4.5.0 released · 2025-04-11
1.14
2025-03-20 · diff ↗
1.13
2025-02-15 · diff ↗
1.12
2024-12-19 · diff ↗
1.11
2024-11-14 · diff ↗
1.10
2024-10-17 · diff ↗
1.9
2024-09-08 · diff ↗
1.8
2024-07-07 · diff ↗
1.7
2024-06-02 · diff ↗
1.6
2024-05-01 · diff ↗
R
R 4.4.0 released · 2024-04-24
1.5
2024-03-26 · diff ↗
1.4
2024-02-16 · diff ↗
1.3
2024-01-12 · diff ↗
1.2
2023-11-29 · diff ↗
1.1
2023-10-23 · diff ↗
1.0
2023-08-25 · diff ↗
0.8
2023-08-07 · diff ↗
0.7.1
2023-06-30 · diff ↗
0.7
2023-05-26 · diff ↗
0.6.1
2023-04-21 · diff ↗
R
R 4.3.0 released · 2023-04-21
0.6
2023-04-02 · diff ↗
0.5.1
2023-02-26 · diff ↗
0.5
2023-01-29 · diff ↗
0.4.1
2022-12-18 · diff ↗
0.4
2022-12-05 · diff ↗
0.3.1
2022-10-31 · diff ↗
0.3
2022-09-30
R
R 4.2.0 released · 2022-04-22

Package metadata

First published: 2022-09-30
Total releases: 41 / 4 yrs
License: MIT + file LICENSE OSI
Minimum R: ≥ 3.5.0
Download size: 1.5 MB
Installed size: not tracked yet
With dependencies: not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("openxlsx2")

Format

Garbuszus, J. M., Barbone, J. M., Kapoulkine, A., Roy, O., & openxlsx authors, . (2026). openxlsx2: Read, Write and Edit 'xlsx' Files (Version 1.28) [Computer software]. https://doi.org/10.32614/CRAN.package.openxlsx2

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for openxlsx2 version 1.28 [Data set]. HJJB, LLC. Data release v2026-08-16. https://doi.org/10.5281/zenodo.21843040

From data release v2026-08-16, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →