Add or remove excel column filters to a worksheet
Usage
wb_add_filter(wb, sheet = current_sheet(), rows, cols)
wb_remove_filter(wb, sheet = current_sheet())Arguments
- wb
A workbook object
- sheet
A worksheet name or index. In
wb_remove_filter(), you may supply a vector of worksheets.- rows
A row number.
- cols
columns to add filter to.
Details
Adds filters to worksheet columns, same as with_filter = TRUE in wb_add_data()
wb_add_data_table() automatically adds filters to first row of a table.
NOTE Can only have a single filter per worksheet unless using tables.
See also
wb_add_data(), wb_add_data_table()
Other worksheet content functions:
col_widths-wb,
grouping-wb,
named_region-wb,
row_heights-wb,
wb_add_conditional_formatting(),
wb_add_data(),
wb_add_data_table(),
wb_add_formula(),
wb_add_pivot_table(),
wb_add_slicer(),
wb_add_thread(),
wb_freeze_pane(),
wb_merge_cells()
Examples
wb <- wb_workbook()
wb$add_worksheet("Sheet 1")
wb$add_worksheet("Sheet 2")
wb$add_worksheet("Sheet 3")
wb$add_data(1, iris)
wb$add_filter(1, row = 1, cols = seq_along(iris))
## Equivalently
wb$add_data(2, x = iris, with_filter = TRUE)
## Similarly
wb$add_data_table(3, iris)
wb <- wb_workbook()
wb$add_worksheet("Sheet 1")
wb$add_worksheet("Sheet 2")
wb$add_worksheet("Sheet 3")
wb$add_data(1, iris)
wb_add_filter(wb, 1, row = 1, cols = seq_along(iris))
## Equivalently
wb$add_data(2, x = iris, with_filter = TRUE)
## Similarly
wb$add_data_table(3, iris)
## remove filters
wb_remove_filter(wb, 1:2) ## remove filters
wb_remove_filter(wb, 3) ## Does not affect tables!