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
Depends:	R (≥ 3.3.0)
Imports:	grDevices, methods, Rcpp, stats, stringi, utils, zip
LinkingTo:	Rcpp
Suggests:	curl, formula.tools, knitr, rmarkdown, testthat
Published:	2025-01-25
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.tar.gz
Windows binaries:	r-devel: openxlsx_4.2.8.zip, r-release: openxlsx_4.2.8.zip, r-oldrel: openxlsx_4.2.8.zip
macOS binaries:	r-release (arm64): openxlsx_4.2.8.tgz, r-oldrel (arm64): openxlsx_4.2.8.tgz, r-release (x86_64): openxlsx_4.2.8.tgz, r-oldrel (x86_64): openxlsx_4.2.8.tgz
Old sources:	openxlsx archive

Reverse dependencies:

Reverse depends:	AntibodyTiters, BayesBP, coefa, EpiSimR, MacBehaviour, sangeranalyseR, SwathXtend, tablaxlsx, uscoauditlog, word.alignment, xlsx2dfs
Reverse imports:	act, actfts, aelab, aftables, agena.ai, aLBI, anabel, aoristic, appreci8R, aquodom, artMS, augmentedRCBD, autoGO, baizer, BayesianDisaggregation, BayesianFitForecast, BeeBDC, bibliometrix, biodosetools, BiostatsUHNplus, BLMEngineInR, blrm, bulkreadr, bursa, cancerradarr, cats, cbaf, CDSS, CHRONOS, CLME, CNVPanelizer, CohortPlat, COINr, ComBatFamQC, compareDF, condformat, conmet, CoTiMA, CRISPRseek, CUFF, D4TAlink.light, datadictionary, dataframeexplorer, ddPCRclust, defineR, deident, DeSciDe, DIDmultiplegtDYN, do, DoLa, dQTG.seq, easysurv, eCerto, editData, emdi, espadon, estadistica, EvalTest, evanverse, export, exvatools, fasstr, fedup, GA4GHshiny, gDRimport, genekitr, gerbil, gmoTree, GRShiny, GTAPViz, GUIDEseq, GWASinspector, HadamardR, HARplus, Holomics, HPAanalyze, htrSPRanalysis, hypeR, idcnrba, IDEATools, ie2misc, immcp, interca, isoorbi, ispdata, istat, izmir, JDCruncheR, joinXL, jstager, KHQ, kidney.epi, KLINK, kmeRtone, knitxl, kutils, lares, leakr, lessR, libr, LifeInsureR, LLSR, macrocol, magpie, MainExistingDatasets, mbX, MetAlyzer, MethReg, MFO, MHCtools, mimsy, miRetrieve, MLMOI, MLmorph, mpindex, netknitr, NormData, odk, OenoKPM, omicsViewer, One4All, openPrimeR, OpenRepGrid, OpenRepGrid.ic, OralOpioids, oreo, ORFID, PhenoSpectra, PhotoGEA, PICB, Pigengene, povmap, presenter, psidR, pxmake, qdap, QTL.gCIMapping, QTL.gCIMapping.GUI, qualitycontrol, R.AlphA.Home, rADA, RALSA, rcdf, REDCapDM, repana, reproducer, RGAP, RJafroc, Rtrack, saeTrafo, samr, sccca, scorecard, sdtmchecks, searchAnalyzeR, seasonalview, SEERaBomb, SEtools, SGCP, sherlock, shinypivottabler, sigFeature, sistec, smoppix, SNPannotator, Spectran, StablePopulation, SurfR, survout, tablespan, tablexlsx, tall, tatoo, TestAnaAPP, TestGenerator, tidyplate, tigerhitteR, TPP, TPP2D, TSAR, umx, uncoverappLib, upstartr, varitas, vaxineR, whSample, xlr, zoomGroupStats
Reverse suggests:	AMR, basictabler, beezdemand, behaviorchange, biometryassist, blastula, BoneProfileR, bruceR, cdid, ces, chronicler, crosstable, cSEM, DAPAR, Ecfun, ecotox, EDCimport, emphatic, epiCleanr, epmfd, exams, expss, FARS, gtsummary, HiResTEC, huxtable, ISAnalytics, JFE, LBDiscover, Lifertable, LLMTranslate, memapp, MetMashR, mitey, modelsummary, mpath, mpower, MSEtool, netCoin, NMOF, parameters, params, pdfcombiner, periscope, periscope2, pivottabler, preregr, psyverse, RaMS, rbiom, readapra, risk.assessr, rock, RRgeo, SARP.moodle, sequoia, sim.BA, sits, struct, structToolbox, tabxplor, testdat, TH.data, tidyxl, timeseriesdb, TimeVizPro, toxEval, tpfp, tstools
Reverse enhances:	jamba

Linking:

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