setAutoFilter-methods {XLConnect} | R Documentation |
Sets an auto-filter on a specified worksheet.
## S4 method for signature 'workbook,character' setAutoFilter(object,sheet,reference) ## S4 method for signature 'workbook,numeric' setAutoFilter(object,sheet,reference)
object |
The |
sheet |
The name or index of the sheet on which to set the auto-filter |
reference |
A cell range specification ( |
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
# 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)