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.
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.