xlsx reading, writing and editing.



openxlsx simplifies the the process of writing and styling Excel xlsx files from R and removes the dependency on Java.


The openxlsx package uses global options to simplfy formatting:

  • options("openxlsx.borderColour" = "black")

  • options("openxlsx.borderStyle" = "thin")

  • options("openxlsx.dateFormat" = "mm/dd/yyyy")

  • options("openxlsx.datetimeFormat" = "yyyy-mm-dd hh:mm:ss")

  • options("openxlsx.numFmt" = NULL)

See the Formatting vignette for examples.

See Also

  • vignette("Introduction", package = "openxlsx")

  • vignette("formatting", package = "openxlsx")

  • writeData

  • writeDataTable

  • write.xlsx

  • read.xlsx

for examples

Want to suggest features or report bugs for rdrr.io? Use the GitHub issue tracker.