Repository files navigation

ThisR package simplifies the creation of.xlsxfiles by providing a high level interface to writing, styling and editingworksheets. Through the use ofRcpp,read/write times are comparable to thexlsxandXLConnect packages withthe added benefit of removing the dependency on Java.

Note:openxlsx is no longer under active development. The package ismaintained, and CRAN warnings will be fixed, but non-critical issues will not beaddressed unless accompanied by a pull request. Packages that depend onopenxlsx do not need to take any action, but for new developments, users areencouraged to use alternatives likereadxl,writexl, oropenxlsx2. Thefirst two packages provide support for reading and writing.xlsx files. Thelatter package is a modern reinterpretation ofopenxlsx and provides similarfunctions to modify worksheets. However, it is not a drop-in replacement, so youmay want to consult resources like theupdate vignette.

Current stable version is available onCRAN via

install.packages("openxlsx",dependencies=TRUE)

install.packages(c("Rcpp","remotes"),dependencies=TRUE)remotes::install_github("ycphs/openxlsx")

Explore the package with a simple example:

library(openxlsx)# Create a new workbook and add a sheetwb<- createWorkbook()addWorksheet(wb,"Sheet 1")# Write data to the sheetwriteData(wb,"Sheet 1",mtcars)# Save the workbooksaveWorkbook(wb,"my_mtcars.xlsx",overwrite=TRUE)

Please let us know which version ofopenxlsx you are using when posting bug reports.

packageVersion("openxlsx")

You can find the NEWS filehere.