Description Usage Arguments Author(s) Examples
Delete contents and styling from a cell.
1 | 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
1 2 3 4 5 6 7 8 9 10 11 12 | ## 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)
saveWorkbook(wb, "deleteDataExample.xlsx", overwrite = TRUE)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.