Learn R Programming

openxlsx (version 4.2.6.1)

removeFilter: Remove a worksheet filter

Description

Removes filters from addFilter() and writeData()

Usage

removeFilter(wb, sheet)

Arguments

wb

A workbook object

sheet

A vector of names or indices of worksheets

Examples

Run this code
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!
if (FALSE) {
saveWorkbook(wb, file = "removeFilterExample.xlsx", overwrite = TRUE)
}

Run the code above in your browser using DataLab