openxlsx2 (version 0.8)

wb_set_grid_lines: Set worksheet gridlines to show or hide.

Description

Set worksheet gridlines to show or hide.

Usage

wb_set_grid_lines(wb, sheet = current_sheet(), show = FALSE, print = show)
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
wb$set_grid_lines(1, show = FALSE)
wb$set_grid_lines("Sheet 2", show = FALSE)