This R package simplifies the creation of .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.
Note: openxlsx is no longer under active development. The package is
maintained, and CRAN warnings will be fixed, but non-critical issues will not be
addressed unless accompanied by a pull request. Packages that depend on
openxlsx do not need to take any action, but for new developments, users are
encouraged to use alternatives like readxl, writexl, or openxlsx2. The
first two packages provide support for reading and writing .xlsx files. The
latter package is a modern reinterpretation of openxlsx and provides similar
functions to modify worksheets. However, it is not a drop-in replacement, so you
may want to consult resources like the
update vignette.
Current stable version is available on CRAN 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 sheet
wb <- createWorkbook()
addWorksheet(wb, "Sheet 1")
# Write data to the sheet
writeData(wb, "Sheet 1", mtcars)
# Save the workbook
saveWorkbook(wb, "my_mtcars.xlsx", overwrite = TRUE)Please let us know which version of openxlsx you are using when posting bug reports.
packageVersion("openxlsx")You can find the NEWS file here.