Delete cell data
Delete contents and styling from a cell.
deleteData(wb, sheet, cols, rows, gridExpand = FALSE)
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 |
Alexander Walker
## write some data wb <- createWorkbook() addWorksheet(wb, "Worksheet 1") x <- data.frame(matrix(runif(200), ncol = 10)) writeData(wb, sheet = 1, x = x, startCol = 2, startRow = 3, colNames = FALSE) ## delete some data deleteData(wb, sheet = 1, cols = 3:5, rows = 5:7, gridExpand = TRUE) deleteData(wb, sheet = 1, cols = 7:9, rows = 5:7, gridExpand = TRUE) deleteData(wb, sheet = 1, cols = LETTERS, rows = 18, gridExpand = TRUE) ## Not run: saveWorkbook(wb, "deleteDataExample.xlsx", overwrite = TRUE) ## End(Not run)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.