wb_set_grid_lines: Modify grid lines visibility in a worksheet

In openxlsx2: Read, Write and Edit 'xlsx' Files

Modify grid lines visibility in a worksheet

Description

Set worksheet grid lines to show or hide. You can also add / remove grid lines when creating a worksheet with wb_add_worksheet(grid_lines = FALSE)

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)

openxlsx2 documentation built on Oct. 18, 2024, 1:07 a.m.