Preface
This is a work in progress book describing the features of openxlsx2 (Barbone and Garbuszus 2024). Having written a book before, I never imagined to do this again and therefore I shall not do it. But still I consider it a nice addition to have something more flexible as our vignettes.
The openxlsx2 book is a comprehensive guide to using the R package openxlsx2 for working with xlsx files. It covers core functionalities such as reading, writing, and editing office open xml (OOXML) spreadsheet files, alongside advanced features like styling worksheets, handling conditional formatting, creating charts, managing pivot tables, and adding data validation. The book also discusses extending the package’s functionality and upgrading from the original openxlsx package. It was created in the hopes that it’s a useful resource for R users needing spreadsheet file manipulation.
This manual was compiled using:
_
platform x86_64-pc-linux-gnu
arch x86_64
os linux-gnu
system x86_64, linux-gnu
status
major 4
minor 4.2
year 2024
month 10
day 31
svn rev 87279
language R
version.string R version 4.4.2 (2024-10-31)
nickname Pile of Leaves
and
Graphics might reflect earlier states and are not constantly updated. If you find any irregularities where our code produces different output than expected, please let us know in the issue tracker at https://github.com/JanMarvin/openxlsx2/.