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.

flexlsx

Lifecycle: experimental Codecov test coverage R-CMD-check

The primary objective of flexlsx is to offer an effortless interface for exporting flextable objects directly to Microsoft Excel. Building upon the robust foundation provided by openxlsx2 and flextable, flexlsx ensures compatibility, precision, and efficiency when working with both trivial and complex tables.

Installation

You can install the development version of flexlsx like so:

# install.packages("remotes")
remotes::install_github("pteridin/flexlsx")

Or install the CRAN release like so:

install.packages("flexlsx")

Example

This is a basic example which shows you how to solve a common problem:

library(flexlsx)

# Create a flextable and an openxlsx2 workbook
ft <- flextable::as_flextable(table(mtcars[,1:2]))
wb <- openxlsx2::wb_workbook()$add_worksheet("mtcars")

# add the flextable ft to the workbook, sheet "mtcars"
# offset the table to cell 'C2'
wb <- wb_add_flextable(wb, "mtcars", ft, dims = "C2")

# save the workbook to a temporary xlsx file
tmpfile <- tempfile(fileext = ".xlsx")
wb$save(tmpfile)

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.