showGridLines: Set worksheet gridlines to show or hide.

Description Usage Arguments Author(s) Examples

View source: R/wrappers.R

Description

Set worksheet gridlines to show or hide.

Usage

1

Arguments

wb

A workbook object

sheet

A name or index of a worksheet

showGridLines

A logical. If FALSE, grid lines are hidden.

Author(s)

Alexander Walker

Examples

1
2
3
4
5
6
7
8
wb <- loadWorkbook(file = system.file("extdata", "loadExample.xlsx", package = "openxlsx"))
names(wb) ## list worksheets in workbook
showGridLines(wb, 1, showGridLines = FALSE)
showGridLines(wb, "testing", showGridLines = FALSE)
## Not run: 
saveWorkbook(wb, "showGridLinesExample.xlsx", overwrite = TRUE)

## End(Not run)

Example output

[1] "IrisSample"   "testing"      "mtcars"       "mtCars Pivot"

openxlsx documentation built on June 16, 2021, 9:06 a.m.