This R package is a modern reinterpretation of the widely used popular
openxlsx package. Similar to its predecessor, it simplifies the creation of xlsx
files by providing a clean interface for writing, designing and editing worksheets.
Based on a powerful XML library and focusing on modern programming flows in pipes
or chains, openxlsx2 allows to break many new ground.
The openxlsx package uses global options to simplify formatting:
options("openxlsx2.borderColor" = "black")
options("openxlsx2.borderStyle" = "thin")
options("openxlsx2.dateFormat" = "mm/dd/yyyy")
options("openxlsx2.datetimeFormat" = "yyyy-mm-dd hh:mm:ss")
options("openxlsx2.numFmt" = NULL)
options("openxlsx2.paperSize" = 9) ## A4
options("openxlsx2.orientation" = "portrait") ## page orientation
options("openxlsx2.sheet.default_name" = "Sheet")
options("openxlsx2.rightToLeft" = NULL)
By default, openxlsx2 uses the American English word for color (written with 'o' instead of the British English 'ou'). However, both spellings are supported. So where the documentation uses a 'color', the function should also accept a 'color'. However, this is not indicated by the autocompletion.
For a full list of all authors that have made this package possible and for whom we are greatful, please see:
system.file("AUTHORS", package = "openxlsx2")
If you feel like you should be included on this list, please let us know. If you have something to contribute, you are welcome. If something is not working as expected, open issues or if you have solved an issue, open a pull request. Please be respectful and be aware that we are volunteers doing this for fun in our unpaid free time. We will work on problems when we have time or need.
This package is licensed under the MIT license and is based on openxlsx (by Alexander Walker and Philipp Schauberger; COPYRIGHT 2014-2022) and pugixml (by Arseny Kapoulkine; COPYRIGHT 2006-2022). Both released under the MIT license.
vignette(package = "openxlsx2")
write_data()
write_datatable()
write_xlsx()
read_xlsx()
for examples