wb_update_table: Update a data table position in a worksheet

In openxlsx2: Read, Write and Edit 'xlsx' Files

Update a data table position in a worksheet

Description

Update the position of a data table, possibly written using wb_add_data_table()

Usage

wb_update_table(wb, sheet = current_sheet(), dims = "A1", tabname)

Arguments

wb	A workbook
sheet	A worksheet
dims	Cell range used for new data table.
tabname	A table name

Details

Be aware that this function does not alter any filter. Excluding or adding rows does not make rows appear nor will it hide them.

Examples

wb <- wb_workbook()$add_worksheet()$add_data_table(x = mtcars)
wb$update_table(tabname = "Table1", dims = "A1:J4")

openxlsx2 documentation built on Oct. 18, 2024, 1:07 a.m.