Description Usage Arguments Value Note Author(s) Examples
This function (a very thin wrapper for openxlsx functions) that writes/appends a data.frame to the specified sheet in a loaded openxlsx workbook.
1 2 |
df |
The data to write. |
wb |
A loaded openxlsx workbook (use openxlsx::loadWorkbook) |
title |
The title to give to the table (only used if style = TRUE). |
sheet |
Name of the sheet to write to, will be created if it does not exist. |
row |
Optional: Also specify the startingrow for writing data. |
format_style |
Set to FALSE if you do not want styling for the data. |
format_values |
Set to FALSE and no formatting will be applied based on variable type. With TRUE, character columns will be left justified, numeric will have 1 decimal place, integer 0, and columns with values between 1 and 0 as percentages. |
append |
Whether or not the function should append or clean the sheet of existing data before writing. |
A list containing data.frames matching the sheets in the .xlsx file. If only one sheet is read, the function returns a data.frame instead.
This function requires openxlsx.
Kristian D. Olsen
1 2 3 |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.