Delete cell data

Description

Remove contents and styling from a cell.

Usage

1
deleteData(wb, sheet, cols, rows, gridExpand = FALSE)

Arguments

wb

A workbook object

sheet

A name or index of a worksheet

cols

columns to delete data from.

rows

Rows to delete data from.

gridExpand

If TRUE, all data in rectangle min(rows):max(rows) X min(cols):max(cols) will be removed.

Author(s)

Alexander Walker

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
## load a workbook
wb <- createWorkbook()
addWorksheet(wb, "Worksheet 1")
x <- data.frame(matrix(runif(200), ncol = 10))
names(x) <- paste("Variable", 1:10)
writeData(wb, sheet = 1, x = x, startCol = 2, startRow = 3, colNames = TRUE)

## delete cell contents
deleteData(wb, sheet = 1, cols = 3:5, rows = 5:7, gridExpand = TRUE)
deleteData(wb, sheet = 1, cols = 7:9, rows = 5:7, gridExpand = TRUE)

saveWorkbook(wb, "deleteDataExample.xlsx", overwrite = TRUE)

Want to suggest features or report bugs for rdrr.io? Use the GitHub issue tracker.