README.md

In openxlsx: Read, Write and Edit xlsx Files

openxlsx

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.

Installation

Stable version

Current stable version is available on CRAN via

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

Development version

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

Example

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)

Bug/feature request

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

packageVersion("openxlsx")

News

You can find the NEWS file here.

openxlsx documentation built on April 4, 2025, 1:37 a.m.