openxlsx2: Read, Write and Edit 'xlsx' Files

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

Version:	1.20
Depends:	R (≥ 3.5.0)
Imports:	R6, Rcpp, grDevices, stringi, utils, zip
LinkingTo:	Rcpp
Suggests:	ggplot2, knitr, mschart (≥ 0.4), rmarkdown, rvg, testthat (≥ 3.0.0), waldo
Published:	2025-09-29
DOI:	10.32614/CRAN.package.openxlsx2
Author:	Jordan Mark Barbone [aut], Jan Marvin Garbuszus [aut, cre], Olivier Roy [ctb], openxlsx authors [cph] (openxlsx package), Arseny Kapoulkine [ctb, cph] (Author of included pugixml code) openxlsx2 author details
Maintainer:	Jan Marvin Garbuszus <jan.garbuszus at ruhr-uni-bochum.de>
BugReports:	https://github.com/JanMarvin/openxlsx2/issues
License:	MIT + file LICENSE
URL:	https://janmarvin.github.io/openxlsx2/, https://github.com/JanMarvin/openxlsx2
NeedsCompilation:	yes
Language:	en-US
Citation:	openxlsx2 citation info
Materials:	README, NEWS
CRAN checks:	openxlsx2 results

Documentation:

Reference manual:	openxlsx2.html , openxlsx2.pdf
Vignettes:	Upgrade from openxlsx (source, R code) Add conditional formatting to a workbook (source, R code) openxlsx2 basic manual (source, R code) Add charts to a workbook (source, R code) Add formulas to a workbook (source, R code) openxlsx2 read to data frame (source, R code) Add styling to a workbook (source, R code)

Downloads:

Package source:	openxlsx2_1.20.tar.gz
Windows binaries:	r-devel: openxlsx2_1.20.zip, r-release: openxlsx2_1.20.zip, r-oldrel: openxlsx2_1.20.zip
macOS binaries:	r-release (arm64): openxlsx2_1.20.tgz, r-oldrel (arm64): openxlsx2_1.20.tgz, r-release (x86_64): openxlsx2_1.20.tgz, r-oldrel (x86_64): openxlsx2_1.20.tgz
Old sources:	openxlsx2 archive

Reverse dependencies:

Reverse imports:	flexlsx, GTAPViz, normref, qol, REDCapCAST
Reverse suggests:	AgePopDenom, correlation, dataquieR, edibble, periscope2, REDCapTidieR, rempsyc, surveytable

Linking:

Please use the canonical form https://CRAN.R-project.org/package=openxlsx2 to link to this page.