onErrorCell-methods {XLConnect} | R Documentation |
This function defines the behavior when reading data from a worksheet and error cells are detected.
## S4 method for signature 'workbook' onErrorCell(object,behavior)
object |
The |
behavior |
The behavior to follow when an error cell is detected. This is normally
specified by a corresponding |
Martin Studer
Mirai Solutions GmbH http://www.mirai-solutions.com
workbook
, readNamedRegion
,
readNamedRegionFromFile
, readWorksheet
,
readWorksheetFromFile
# errorCell xlsx file from demoFiles subfolder of package XLConnect demoExcelFile <- system.file("demoFiles/errorCell.xlsx", package = "XLConnect") # Load workbook wb <- loadWorkbook(demoExcelFile) # Set error behavior to XLC$ERROR.WARN when detecting error cells # Note: this is the default behavior onErrorCell(wb, XLC$ERROR.WARN) # Alternatively: wb$onErrorCell(XLC$ERROR.WARN) # Read named region 'MyData' (with default header = TRUE) data <- readNamedRegion(wb, name = "MyData") # Now set error behavior to XLC$ERROR.STOP to immediately # issue an exception and stop in case an error cell is # detected onErrorCell(wb, XLC$ERROR.STOP) # Alternatively: wb$onErrorCell(XLC$ERROR.STOP) # Read (again) named region 'MyData' (with default header = TRUE) res <- try(readNamedRegion(wb, name = "MyData")) # Did we get an error? print(is(res, "try-error"))