Learn R Programming

openxlsx2 (version 0.6.1)

wb_add_chartsheet: Add a chartsheet to a workbook

Description

Add a chartsheet to a workbook

Usage

wb_add_chartsheet(
  wb,
  sheet = next_sheet(),
  tabColor = NULL,
  zoom = 100,
  visible = c("true", "false", "hidden", "visible", "veryhidden"),
  ...
)

Arguments

wb

A Workbook object to attach the new worksheet

sheet

A name for the new worksheet

tabColor

Color of the worksheet tab. A valid color (belonging to colors()) or a valid hex color beginning with "#"

zoom

A numeric between 10 and 400. Worksheet zoom level as a percentage.

visible

If FALSE, sheet is hidden else visible.

...

...

Details

After chartsheet creation a chart must be added to the sheet. Otherwise the chartsheet will break the workbook.

See Also

wb_add_mschart()

Other workbook wrappers: wb_add_data_table(), wb_add_data(), wb_add_formula(), wb_add_pivot_table(), wb_add_worksheet(), wb_clone_worksheet(), wb_copy_cells(), 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