setAutoFilter-methods {XLConnect} | R Documentation |
Setting auto-filters on worksheets
Description
Sets an auto-filter on a specified worksheet.
Usage
## S4 method for signature 'workbook,character'
setAutoFilter(object,sheet,reference)
## S4 method for signature 'workbook,numeric'
setAutoFilter(object,sheet,reference)
Arguments
object |
The |
sheet |
The name or index of the sheet on which to set the auto-filter |
reference |
A cell range specification ( |
Author(s)
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
See Also
Examples
## Not run:
# Load workbook (create if not existing)
wb <- loadWorkbook("autofilter.xlsx", create = TRUE)
# Create a worksheet named 'mtcars'
createSheet(wb, name = "mtcars")
# Create a named region called 'mtcars' on the sheet called 'mtcars'
createName(wb, name = "mtcars", formula = "mtcars!$A$1")
# Write built-in data set 'mtcars' to the above defined named region
# (using header = TRUE)
writeNamedRegion(wb, mtcars, name = "mtcars")
# Set an auto-filter for the named region written above
setAutoFilter(wb, sheet = "mtcars", reference = aref("A1", dim(mtcars)))
# Save workbook (this actually writes the file to disk)
saveWorkbook(wb)
# clean up
file.remove("autofilter.xlsx")
## End(Not run)
[Package XLConnect version 1.0.10 Index]