clearRangeFromReference-methods {XLConnect} | R Documentation |
Clearing cell ranges in a workbook
Description
Clears cell ranges specified by area reference in a workbook
.
Usage
## S4 method for signature 'workbook,character'
clearRangeFromReference(object, reference)
Arguments
object |
The |
reference |
|
Details
Clearing a cell range means to clear all the cells associated with that range. This
method is very similar to clearRange
.
Author(s)
Nicola Lambiase
Mirai Solutions GmbH https://mirai-solutions.ch
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"))
## End(Not run)
[Package XLConnect version 1.0.10 Index]