Set worksheet gridlines to show or hide. — wb_grid_lines • openxlsx2

Set worksheet gridlines to show or hide.

Usage

wb_grid_lines(wb, sheet = current_sheet(), show = FALSE, print = show)

Arguments

wb: A workbook object
sheet: A name or index of a worksheet
show: A logical. If FALSE, grid lines are hidden.
print: A logical. If FALSE, grid lines are not printed.

Examples

wb <- wb_workbook()$add_worksheet()$add_worksheet()
wb$get_sheet_names() ## list worksheets in workbook
#>   Sheet 1   Sheet 2 
#> "Sheet 1" "Sheet 2" 
wb$grid_lines(1, show = FALSE)
wb$grid_lines("Sheet 2", show = FALSE)