Set worksheet gridlines to show or hide.

showGridLines(wb, sheet, showGridLines = FALSE)

Arguments

wb

A workbook object

sheet

A name or index of a worksheet

showGridLines

A logical. If FALSE, grid lines are hidden.

Author

Alexander Walker

Examples

wb <- loadWorkbook(file = system.file("extdata", "loadExample.xlsx", package = "openxlsx")) names(wb) ## list worksheets in workbook
#> [1] "IrisSample" "testing" "mtcars" "mtCars Pivot"
showGridLines(wb, 1, showGridLines = FALSE) showGridLines(wb, "testing", showGridLines = FALSE) if (FALSE) { saveWorkbook(wb, "showGridLinesExample.xlsx", overwrite = TRUE) }