clearRangeFromReference-methods
From XLConnect v1.0.1
by Martin Studer
Clearing cell ranges in a workbook
Clears cell ranges specified by area reference in a '>workbook
.
Usage
# S4 method for workbook,character
clearRangeFromReference(object, reference)
Arguments
Details
Clearing a cell range means to clear all the cells associated with that range. This
method is very similar to clearRange
.
See Also
'>workbook
, clearSheet
,
clearNamedRegion
,
clearRange
,
clearSheet
Examples
# NOT RUN {
# mtcars xlsx file from demoFiles subfolder of
# package XLConnect
demoExcelFile <- system.file("demoFiles/mtcars.xlsx",
package = "XLConnect")
# Load workbook
wb <- loadWorkbook(demoExcelFile)
# Clear ranges A5:D6 and G5:I7 on sheet mtcars
clearRangeFromReference(wb, reference = c("mtcars!A5:D6",
"mtcars!G5:I7"))
# }
Community examples
Looks like there are no examples yet.