clearRangeFromReference-methods | R Documentation |
Clears cell ranges specified by area reference in a workbook
.
## S4 method for signature 'workbook,character' clearRangeFromReference(object, reference)
object |
The |
reference |
|
Clearing a cell range means to clear all the cells associated with that range. This
method is very similar to clearRange
.
Nicola Lambiase
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
, clearSheet
,
clearNamedRegion
,
clearRange
,
clearSheet
## 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)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.