Skip to contents

Adds a processed table to an Excel sheet with accessible formatting including proper headers, styling, and multi-line text support.

Usage

wb_add_procr_table_accessible(
  wb,
  tab,
  cell = "A1",
  sheet = openxlsx2::current_sheet(),
  sep_varformat = ": ",
  sep_varvalue = ", ",
  digits = 0,
  footnote_operation = remove_footnotes
)

Arguments

wb

An openxlsx2 wbWorkbook object.

tab

A procr_table object.

cell

Starting cell reference (e.g., "A1") where the table will be placed. Default is "A1".

sheet

Sheet name or index where the table will be added. Default is openxlsx2::current_sheet(). If the sheet does not exist it will be created.

sep_varformat

Separator appended after a varformat label to indicate dimension boundaries. Default is ": ".

sep_varvalue

Separator appended after a varvalue label within the same dimension. Default is ", ".

digits

Number of decimal places for numeric formatting. Default is 0.

footnote_operation

Function applied to all text labels to handle {{footnote}} markers. Default is remove_footnotes, which strips them.

Value

The workbook wb, modified in place and returned invisibly.