clearRange-methods | R Documentation |
Clears cell ranges in a workbook
.
## S4 method for signature 'workbook,numeric' clearRange(object, sheet, coords) ## S4 method for signature 'workbook,character' clearRange(object, sheet, coords)
object |
The |
sheet |
The name or index of the worksheet in which to clear cell ranges |
coords |
Numeric vector of length 4 or numeric matrix with 4 columns
where the elements of the vector or rows in the matrix refer to
the coordinates of the top-left and bottom-right corners of the ranges
to clear. I.e. a vector or each row specifies the coordinates
{top row, left column, bottom row, right column}. You may use
|
Clearing a cell range means to clear all the cells associated with that range.
Nicola Lambiase
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
, clearSheet
,
clearNamedRegion
,
clearRangeFromReference
,
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 range from top left corner (4,2) ^= B4 to # bottom right corner (6,4) ^= D6 clearRange(wb, sheet = "mtcars", coords = c(4, 2, 6, 4)) # Clear two ranges in one go ... mat = matrix(c(5, 1, 6, 4, 5, 7, 7, 9), ncol = 4, byrow = TRUE) clearRange(wb, sheet = "mtcars", coords = mat) # The above is equivalent to ... clearRange(wb, sheet = "mtcars", coords = aref2idx(c("A5:D6", "G5:I7"))) # This in turn is the same as ... 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.