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.
You can install the development version of flexlsx
like so:
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)