This function defines the behavior when reading data from a worksheet and error cells are detected.
## S4 method for signature 'workbook' onErrorCell(object,behavior)
The behavior to follow when an error cell is detected. This is normally
specified by a corresponding
Mirai Solutions GmbH http://www.mirai-solutions.com
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
# 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"))
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.