openxlsx: Read, Write and Edit xlsx Files

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.

Version:	4.2.8.1
Depends:	R (≥ 3.3.0)
Imports:	grDevices, methods, Rcpp, stats, stringi, utils, zip
LinkingTo:	Rcpp
Suggests:	curl, formula.tools, knitr, rmarkdown, testthat
Published:	2025-10-31
DOI:	10.32614/CRAN.package.openxlsx
Author:	Philipp Schauberger [aut], Alexander Walker [aut], Luca Braglia [ctb], Joshua Sturm [ctb], Jan Marvin Garbuszus [ctb, cre], Jordan Mark Barbone [ctb], David Zimmermann [ctb], Reinhold Kainhofer [ctb]
Maintainer:	Jan Marvin Garbuszus <jan.garbuszus at ruhr-uni-bochum.de>
BugReports:	https://github.com/ycphs/openxlsx/issues
License:	MIT + file LICENSE
URL:	https://ycphs.github.io/openxlsx/index.html, https://github.com/ycphs/openxlsx
NeedsCompilation:	yes
Language:	en-US
Materials:	README, NEWS
In views:	ReproducibleResearch
CRAN checks:	openxlsx results

Documentation:

Reference manual:	openxlsx.html , openxlsx.pdf
Vignettes:	Formating with xlsx (source, R code) Introduction (source, R code)

Downloads:

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

Reverse dependencies:

Reverse depends:	AntibodyTiters, BayesBP, coefa, EpiSimR, MacBehaviour, sangeranalyseR, SwathXtend, tablaxlsx, uscoauditlog, xlsx2dfs
Reverse imports:	act, actfts, aelab, AeroEvapR, agena.ai, agrobox, AHPWR, aLBI, anabel, aoristic, appreci8R, aquodom, artMS, authordown, autoGO, baizer, BayesianFitForecast, BeeBDC, bibliometrix, biodosetools, BiostatsUHNplus, BLMEngineInR, blrm, bulkreadr, bursa, CalibraCurve, cancerradarr, cats, cbaf, CbKST, CDSS, CHRONOS, CLME, CNVPanelizer, CohortPlat, COINr, ComBatFamQC, compareDF, conmet, CoTiMA, CRISPRseek, CUFF, D4TAlink.light, datadictionary, dataframeexplorer, datazoom.amazonia, DDESONN, ddPCRclust, DedooseR, defineR, deident, DeSciDe, DIDmultiplegtDYN, DIVINE, dosr, DOtools, dQTG.seq, earthUI, easysurv, eCerto, editData, emdi, episomer, espadon, estadistica, EvalTest, export, exvatools, Familia, fasstr, FastRet, fedup, G4SNVHunter, GA4GHshiny, gDRimport, genekitr, gerbil, gmoTree, goatea, GRShiny, GTAPViz, GUIDEseq, GWASinspector, HadamardR, HARplus, Holomics, HPAanalyze, html2excel, htrSPRanalysis, hybridEHR, hypeR, idcnrba, IDEATools, ie2misc, interca, isoorbi, ispdata, istat, izmir, JDCruncheR, joinXL, jsmodule, jstager, KHQ, kidney.epi, KLINK, kmeRtone, knitxl, kutils, lares, LatSquare, LDAShiny, leakr, lessR, libr, LifeInsureR, LISTC, LitFetchR, LLSR, lulab.utils, macrocol, magpie, MainExistingDatasets, mbX, mcmsector, MetAlyzer, MethReg, MFO, MHCtools, mimsy, MixStable, MLMOI, MLmorph, mpindex, MVLs, netknitr, NetSurvProx, NormData, notame, nprcgenekeepr, NSMM, odk, OenoKPM, omicsViewer, One4All, openNCAI, openPrimeR, OpenRepGrid, OpenRepGrid.ic, OralOpioids, oreo, ORFID, parati, PhenoSpectra, PhotoGEA, PICB, Pigengene, presenter, psidR, pxmake, qdap, QTL.gCIMapping, QTL.gCIMapping.GUI, qualitycontrol, rADA, RALSA, rCoreGage, REDCapDM, repana, reproducer, RGAP, RJafroc, Rtrack, saeTrafo, samr, scaledescr, sccca, scimetr, scorecard, scToppR, sdtmchecks, searchAnalyzeR, seasonalview, SEERaBomb, SeroTrackR, SEtools, sherlock, shinypivottabler, sigFeature, SimtablR, sistec, smoppix, SNPannotator, sov, Spectran, splitr, StablePopulation, SurfR, survout, svySE, tabbitR, tablespan, tablexlsx, tall, tatoo, TestAnaAPP, TestGenerator, tidyplate, tigerhitteR, TPP, TPP2D, TSAR, tsg, umx, uncoverappLib, upstartr, uteals, varitas, vaxineR, vennDiagramLab, wizaRdry, xlr, zoomGroupStats
Reverse suggests:	actiRhythm, alsi, AMR, autocodebook, basictabler, bayesianOU, behaviorchange, bivarhr, blastula, BoneProfileR, bruceR, cdid, ces, chronicler, climatehealth, clinCompare, condformat, crosstable, cSEM, DAPAR, dceasimR, distilleR, easyLSEA, Ecfun, ecotox, EDCimport, emphatic, epicR, epmfd, exams, expss, FARS, fonctionr, GapAnalysis, greenbook, gtsummary, HiResTEC, htaBIM, httkexamples, huxtable, iDIFr, IRTC, ISAnalytics, isoreader2, JFE, LBDiscover, lcmsPlot, Lifertable, LLMTranslate, magentabook, memapp, metasurvey, MetMashR, mitey, modelsummary, motherduck, mpower, MSEtool, MutSeqR, netCoin, NMOF, omicsTools, omopgenerics, parameters, PathwayVote, pdfcombiner, periscope, periscope2, pivottabler, PsychoMatic, psyverse, RaMS, rbiom, rcdf, read.abares, readapra, rgsrs, risk.assessr, rock, rolescry, RRgeo, rtemis, rwetools, SARP.moodle, sequoia, sim.BA, sits, SQIpro, struct, structToolbox, tabxplor, testdat, TextAnalysisR, TH.data, tidyexposomics, tidyxl, TimeVizPro, tinytrail, toxEval, tpfp, tstools
Reverse enhances:	jamba

Linking:

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