openxlsx2 (version 0.7)

wb_grid_lines: Set worksheet gridlines to show or hide.

Description

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_load(file = system.file("extdata", "loadExample.xlsx", package = "openxlsx2"))
wb$get_sheet_names() ## list worksheets in workbook
wb$grid_lines(1, show = FALSE)
wb$grid_lines("testing", show = FALSE)