The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

:package: Package tablexlsx

R package that allows to export data frames from R to xslx workbooks.

Installation

remotes::install_github("ddotta/tablexlsx")

library(tablexlsx)

Why this package ?

This package is a wrapper of some functions from the great openxlsx package.

The purpose of this package is to meet the needs of R users who want to export data frames in xlsx files to share their data and results with other users not necessarily R users.

The goal is to get an API that is as simple as possible to use. It’s intended to meet the needs of users who want to create clean, well-documented xlsx files (with a title and footnotes).

The package will be improved over time and will include new features based on the needs expressed by users. To do so, feel free to open an issue here.

Advantages

Some advantages of using this package :

• A simpler syntax for common export operations of excel files;
  
• It can write several data frames in the same sheet one below the other;
  
• It can merge modalities for one or several columns;
  
• It can automatically open files as soon as they are created so you can inspect your workbook.
• Data frames to be exported in xlsx files can be passed as an argument in functions as simple tables or list of tables.
  
• The main function of the package toxlsx() works interchangeably with %>% and |> operators and these 3 syntaxes below are equivalent :

toxlsx(object = iris, path = mypath)
iris |> toxlsx(path = mypath)
iris %>% toxlsx(path = mypath)

:point_right: For more, see examples gallery in vignette :mag_right:

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.