R Observatory: Metrics for openxlsx version 4.2.9

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

openxlsx

4.2.9Package record

Read, Write and Edit xlsx Files

210packages dependsuggested by 107

5.2Mdownloads / year

71.5%test coverage

13/13flavors OK

Overview

About

Maintained by Jan Marvin GarbuszusCRAN page ↗GitHub ↗Website ↗Issues ↗

Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of 'Rcpp', read/write times are comparable to the 'xlsx' and 'XLConnect' packages with the added benefit of removing the dependency on Java.

Changes in 4.2.9

Fix for date detection (@sims1253, #539)
Add overwrite support to writeData() to clear stale cells when rewriting with a smaller data range (@Rong-Zh, #536)

From NEWS.md in the release

Install

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

install.packages("openxlsx", 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("ycphs/openxlsx")

Development version from ycphs/openxlsx. 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-openxlsx

Fast Ubuntu binaries via r2u (no compilation). The cranapt setup runs once and is skipped when it is already enabled. We list this channel from recorded r2u download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

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-openxlsx

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-openxlsx

RPMs auto-built from CRAN on openSUSE OBS (Tumbleweed). We list this channel from recorded autoCRAN download activity rather than from a live index of the repository, so treat it as last known rather than guaranteed.

Health

CRAN checks

13OK

CRAN check page ↗

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

Status changes

OK13 OK2026-09-07
NOTE11 OK, 2 NOTE2026-07-16
OK13 OK2026-05-02
NOTE12 OK, 2 NOTE2026-04-22
ERROR11 OK, 2 NOTE, 1 ERROR2026-04-18

Show 1 earlier changeHide 1 earlier change

NOTE12 OK, 2 NOTE2026-03-10

Advisories

none known

How this is measured·How advisories are found

Documentation

In release 4.2.9

READMEYes · 209 wordsVignettesYes · 2 · dynamicNEWSYes · 100% structured · mentions 4.2.9Citation fileNoWebsiteYes · pkgdown

Help pages: 86 (1 internal)includes a package overview page
Examples that run: 93%70 run in a plain check · 5 never run
Exported functions with examples: 91%
Documented parameters: 98%
Return-value docs: 29%
Help pages citing references: 0%

Vignettes (2)

Formating with xlsx HTML
Introduction HTML

How these are measured

Downloads

5.2M

CRAN downloads in the past year

Rank #145 · ~14.1K/day · ~429.6K/mo

Releases R versions

Daily download trend is not available in this view yet.

424.6K30 days

1.2M90 days

5.2M1 year

Compare downloads with other packages →

Also on16K r2u200 autocran92K conda_forge682 bioconda780 c2d4u

How downloads are counted

Repository

ycphs/openxlsx ↗Account: ycphs

241Stars

76Forks

18Open issues

3Open PRs

10Releases

1,781Commits

75Commit identities

cranxlsxr

1,781 commits · Last activity 2026-09-02 · 0% stars, 30d

Responsiveness

How these are sampled

PRs merged (all time): 88%
Median days to close, 50 most recently updated closed issues: 375
Median days to close, 50 most recently updated closed PRs: 4

Stars over time

2025-10-14 · 2362026-08-28 · 241

How these are measured

PracticesBeta

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

Checks run against github.com/ycphs/openxlsx on 2026-10-11.

Continuous integration (2)

GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel

Governance and community (4)

Code of conductContributing guideIssue templatesSupport guide

Docs source (3)

pkgdown

GitHub Pages site last deployed 2026-09-02 · The repository has a site deploy workflow

Coverage (1)

Coverage reporting (Codecov)

Show all practicesHide 3 practices

Reproducibility and dev environment (1)

data-raw/

Automation and maintenance (1)

pre-commit

Lint, format, editor (3)

lintrLint workflowRStudio project

How this is detected·Detection ruleset v3 (2026-09-26)

AI coding toolsBeta

This repository has an AI review tool set up.

Review tools

Copilot code review
Commits: some accepting its review suggestions, count not recorded

How this is detected·Detection ruleset v4 (updated 2026-09-27)

Dependencies

Declared dependencies

11 external dependencies (excludes base and recommended)

Installing openxlsx adds 4 packages (4 with compiled code, 14 MB of source tarballs). Heaviest: stringi 11 MB, Rcpp 1.8 MB, cli 629 KB.

Depends (1)

R >= 3.3.0

Imports (7)

grDevicesmethodsRcppstatsstringiutilszip

LinkingTo (1)

Rcpp

Suggests (8)

curl formula.tools ggplot2 jpeg knitr rmarkdownsurvivaltestthat

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

210direct

33indirect

Depends 8 · Imports 202

Suggested by 107

Show the 48 most downloaded dependentsHide the 48 most downloaded dependents

Depends, Imports or LinkingTo, most downloaded first

and 162 more dependents and 107 packages that suggest it on CRAN ↗

How these are counted

Code & Tests

Datasets

People & History

People (8)

Jan Marvin Garbuszus

Contributor, Maintainer since 4.2.6 (2024) · added in 4.2.4

Philipp Schauberger

Author · added in 4.1.2

Alexander Walker

Author

Jordan Mark Barbone

Contributor · added in 4.2.4

Luca Braglia

Contributor · added in 2.0.1

Reinhold Kainhofer

Contributor · added in 4.2.7

Joshua Sturm

Contributor · added in 4.2.2

David Zimmermann

Contributor · added in 4.2.6

Previously maintained by Philipp Schauberger (1.0.3 to 4.2.5.2).

Releases (27)

Pick two releases to compare their code metrics.

4.2.9Latest
record
2026-09-02 · current release · diff ↗
R
R 4.6.0 released · 2026-04-24
4.2.8.1
record
2025-10-31 · diff ↗
R
R 4.5.0 released · 2025-04-11
4.2.8
record
2025-01-25 · diff ↗
4.2.7.1
record
2024-09-20 · diff ↗
4.2.7
record
2024-08-30 · diff ↗ ·
added 4 exports
auto_heights, getWindowSize, get_worksheet_entries, setWindowSize
4.2.6.1
record
2024-07-23 · diff ↗
4.2.6
record
2024-07-23 · diff ↗ ·
added 1 export
deleteDataColumn
R
R 4.4.0 released · 2024-04-24
R
R 4.3.0 released · 2023-04-21
4.2.5.2
record
2023-02-06 · diff ↗
4.2.5.1
record
2022-10-24 · diff ↗
R
R 4.2.0 released · 2022-04-22
4.2.5
record
2021-12-14 · diff ↗ ·
added 3 exports
col2int, deleteNamedRegion, temp_xlsx
4.2.4
record
2021-06-16 · diff ↗ ·
added 6 exports
activeSheet<-, activeSheet, buildWorkbook, op.openxlsx, openxlsx_getOp, openxlsx_setOp

Show 26 earlier eventsHide 26 earlier events

R
R 4.1.0 released · 2021-05-18
4.2.3
record
2020-10-27 · diff ↗
4.2.2
record
2020-09-17 · diff ↗ ·
added 4 exports
groupColumns, groupRows, ungroupColumns, ungroupRows
4.1.5
record
2020-05-06 · diff ↗ ·
added 3 exports
addCreator, getCreators, setLastModifiedBy
R
R 4.0.0 released · 2020-04-24
4.1.4
record
2019-12-06 · diff ↗ ·
added 1 export
getCellRefs
4.1.3
record
2019-11-07 · diff ↗
unarchivedReturned to CRAN
2019-10-29
4.1.2
record
2019-10-29 · diff ↗ ·
added 3 exports
cloneWorksheet, protectWorkbook, protectWorksheet
orphanedOrphaned by its maintainer
2019-05-28
check issues were not addressed despite reminder gcc 9 warnings
4.1.0.1
record
2019-05-28 · diff ↗
R
R 3.6.0 released · 2019-04-26
4.1.0
record
2018-05-26 · diff ↗
R
R 3.5.0 released · 2018-04-23
R
R 3.4.0 released · 2017-04-21
4.0.17
record
2017-03-23 · diff ↗ ·
added 2 exports
getTables, removeTable
4.0.0
record
2017-01-09 · diff ↗ ·
added 9 exports
sheetVisibility<-, sheetVisible<-, copyWorkbook, createNamedRegion, dataValidation, makeHyperlinkString, pageBreak, sheetVisibility, sheetVisible
R
R 3.3.0 released · 2016-05-03
3.0.0
record
2015-07-03 · diff ↗ ·
added 7 exports
createComment, getNamedRegions, getSheetNames, int2col, removeComment, writeComment, writeFormula
R
R 3.2.0 released · 2015-04-16
2.4.0
record
2015-03-07 · diff ↗ ·
removed 1 export
names.Workbook

added 2 exports
conditionalFormatting, getDateOrigin
2.2.1
record
2014-10-18 · diff ↗ ·
removed 1 export
orderCellRef

added 3 exports
addFilter, removeFilter, setHeaderFooter
2.0.15
record
2014-07-27 · diff ↗ ·
added 2 exports
convertToDateTime, names.Workbook
2.0.1
record
2014-05-29 · diff ↗ ·
added 6 exports
worksheetOrder<-, convertToDate, getBaseFont, openXL, worksheetOrder, write.xlsx
1.0.3
record
2014-04-21
R
R 3.1.0 released · 2014-04-10

Package metadata

First published: 2014-04-21
Total releases: 27 / 12 yrs
License: MIT + file LICENSE OSI · relicensed from GPL-3 in 4.1.0
Minimum R: ≥ 3.3.0
Bundled data: 7.0 KB / 2 files
Download size: 1.3 MB

Appears in task views

Reproducible Research

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("openxlsx")

Format

Garbuszus, J. M., Barbone, J. M., Braglia, L., Kainhofer, R., Schauberger, P., Sturm, J., Walker, A., & Zimmermann, D. (2026). openxlsx: Read, Write and Edit xlsx Files (Version 4.2.9) [Computer software]. https://doi.org/10.32614/CRAN.package.openxlsx

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

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 openxlsx version 4.2.9 [Data set]. HJJB, LLC. Data release v2026-10-17. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-17, 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 →