Description
Exporting 'flextable' to 'xlsx' Files.
Description
Exports 'flextable' objects to 'xlsx' files, utilizing functionalities provided by 'flextable' and 'openxlsx2'.
README.md
flexlsx
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")
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)