Last data update: 2014.03.03
|
R: removes worksheet filter from addFilter and writeData
removeFilter | R Documentation |
removes worksheet filter from addFilter and writeData
Description
removes worksheet filter from addFilter and writeData
Usage
removeFilter(wb, sheet)
Arguments
wb |
A workbook object
|
sheet |
A vector of names or indices of worksheets
|
Examples
wb <- createWorkbook()
addWorksheet(wb, "Sheet 1")
addWorksheet(wb, "Sheet 2")
addWorksheet(wb, "Sheet 3")
writeData(wb, 1, iris)
addFilter(wb, 1, row = 1, cols = 1:ncol(iris))
## Equivalently
writeData(wb, 2, x = iris, withFilter = TRUE)
## Similarly
writeDataTable(wb, 3, iris)
## remove filters
removeFilter(wb, 1:2) ## remove filters
removeFilter(wb, 3) ## Does not affect tables!
saveWorkbook(wb, file = "removeFilterExample.xlsx", overwrite = TRUE)
Results
|