Write an lt table into a worksheet — wb_add

The `lt` package builds its HTML in JavaScript when the page is viewed, so there is no table to read on the R side. This helper asks `lt` to bake the table to static HTML first and then hands the result to [wb_add_html()].

Usage

wb_add_lt(wb, x, sheet = current_sheet(), dims = "A1", method = "auto", ...)

Arguments

wb: A `wbWorkbook` object.
x: An `lt_tbl` object.
sheet: The worksheet to write to.
dims: Cell reference of the top left corner.
method: How `lt` should bake the table: `"node"` or `"browser"` to force a renderer, `"auto"` to use whichever is available.
...: Passed on to [wb_add_html()].

Value

The workbook, invisibly.

Details

Baking needs Node.js or a Chromium based browser on the machine.

Examples

# needs the lt package and a Node.js or browser install
if (FALSE) { # \dontrun{
library(openxlsx2)

tbl <- lt::lt(data.frame(a = c("x", "y"), n = c(1234.5, 67.89)))
tbl <- lt::lt_format(tbl, ~ n, decimals = 2, big_mark = ",")

wb <- wb_workbook()$add_worksheet()
wb <- wb_add_lt(wb, tbl, dims = "B2")
} # }