View source: R/utils-openxlsx.R
add_data_sheet | R Documentation |
Add data to sheet
add_data_sheet( wb, data, sheetname, tableStyle = "TableStyleLight8", bandedRows = TRUE, bandedCols = TRUE, ..., override = TRUE )
wb |
A Workbook object to attach the new worksheet and table |
data |
A dataframe. |
sheetname |
The worksheet to write to. Can be the worksheet index or name. |
tableStyle |
Any excel table style name or "none". |
bandedRows |
Logical. If TRUE, rows are colour banded |
bandedCols |
Logical. If TRUE, the columns are colour banded |
... |
Additional arguments passed to openxlsx::writeDataTable that are not already listed |
override |
Logical. If TRUE, will delete the sheetname (if present) |
A wrapper function to use within the openxlsx workbook building. This adds additional functionality to override within the function and provide an output that can be piped.
These should be applied to a string starting with [openxlsx::createWorkbook()] then piped through with the functions below.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.