R6 class for a Workbook Chart Sheet

A chart sheet

Value

A character vector of xml

Public fields

sheetPr

Sheet something?

sheetViews

Something

sheetProtection

sheetProtection

customSheetViews

customSheetViews

pageMargins

page margins

pageSetup

pageSetup

headerFooter

headerFooter

drawing

drawing

drawingHF

drawingHF

picture

picture

webPublishItems

webPublishItems #' @field hyperlinks hyperlinks hyperlinks = NULL,

relships

relships

Methods

Public methods

• wbChartSheet$new()

• wbChartSheet$get_prior_sheet_data()

• wbChartSheet$set_sheetview()

• wbChartSheet$clone()

---

Method new()

Create a new workbook chart sheet object

Usage

wbChartSheet$new(tabColor = tabColor)

Arguments

tabColor

character a tab color to set

Returns

The wbChartSheet object

---

Method get_prior_sheet_data()

get (prior) sheet data

Usage

wbChartSheet$get_prior_sheet_data()

---

Method set_sheetview()

add sheetview

Usage

wbChartSheet$set_sheetview(
  color_id = NULL,
  default_grid_color = NULL,
  right_to_left = NULL,
  show_formulas = NULL,
  show_grid_lines = NULL,
  show_outline_symbols = NULL,
  show_row_col_headers = NULL,
  show_ruler = NULL,
  show_white_space = NULL,
  show_zeros = NULL,
  tab_selected = NULL,
  top_left_cell = NULL,
  view = NULL,
  window_protection = NULL,
  workbook_view_id = NULL,
  zoom_scale = NULL,
  zoom_scale_normal = NULL,
  zoom_scale_page_layout_view = NULL,
  zoom_scale_sheet_layout_view = NULL,
  ...
)

Arguments

color_id, default_grid_color

Integer: A color, default is 64

right_to_left

Logical: if TRUE column ordering is right to left

show_formulas

Logical: if TRUE cell formulas are shown

show_grid_lines

Logical: if TRUE the worksheet grid is shown

show_outline_symbols

Logical: if TRUE outline symbols are shown

show_row_col_headers

Logical: if TRUE row and column headers are shown

show_ruler

Logical: if TRUE a ruler is shown in page layout view

show_white_space

Logical: if TRUE margins are shown in page layout view

show_zeros

Logical: if FALSE cells containing zero are shown blank if !showFormulas

tab_selected

Integer: zero vector indicating the selected tab

top_left_cell

Cell: the cell shown in the top left corner / or top right with rightToLeft

view

View: "normal", "pageBreakPreview" or "pageLayout"

window_protection

Logical: if TRUE the panes are protected

workbook_view_id

integer: Pointing to some other view inside the workbook

zoom_scale, zoom_scale_normal, zoom_scale_page_layout_view, zoom_scale_sheet_layout_view

Integer: the zoom scale should be between 10 and 400. These are values for current, normal etc.

...

additional arguments

sheet

sheet

Returns

The wbWorksheetObject, invisibly

---

Method clone()

The objects of this class are cloneable with this method.

Usage

wbChartSheet$clone(deep = FALSE)

Arguments

deep

Whether to make a deep clone.