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:
# 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)
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4