clearRangeFromReference-methods

0th

Percentile

Clearing cell ranges in a workbook

Clears cell ranges specified by area reference in a '>workbook.

Keywords
methods, utilities
Usage
# S4 method for workbook,character
clearRangeFromReference(object, reference)
Arguments
object

The '>workbook to use

reference

character specifying an area reference in the form 'SheetX!A7:B19'

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

Aliases
  • clearRangeFromReference
  • clearRangeFromReference-methods
  • clearRangeFromReference,workbook,character-method
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"))
# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.