Add a chartsheet to a workbook
wb_add_chartsheet(
wb,
sheet = next_sheet(),
tabColour = NULL,
zoom = 100,
visible = c("true", "false", "hidden", "visible", "veryhidden")
)A Workbook object to attach the new worksheet
A name for the new worksheet
Colour of the worksheet tab. A valid colour (belonging to colours()) or a valid hex colour beginning with "#"
A numeric between 10 and 400. Worksheet zoom level as a percentage.
If FALSE, sheet is hidden else visible.
After chartsheet creation a chart must be added to the sheet. Otherwise the chartsheet will break the workbook.
wb_add_mschart()
Other workbook wrappers:
wb_add_data_table(),
wb_add_data(),
wb_add_formula(),
wb_add_worksheet(),
wb_clone_worksheet(),
wb_creators,
wb_freeze_pane(),
wb_get_base_font(),
wb_save(),
wb_set_col_widths(),
wb_set_last_modified_by(),
wb_set_row_heights(),
wb_workbook(),
workbook_grouping,
ws_cell_merge