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.