clearSheet-methods | R Documentation |
Clears worksheets with specified names or indices in a workbook
.
## S4 method for signature 'workbook,numeric' clearSheet(object, sheet) ## S4 method for signature 'workbook,character' clearSheet(object, sheet)
object |
The |
sheet |
The name or the index of the worksheet to clear |
Clearing a worksheet means to clear all the cells in that worksheet. Consequently, the saved workbook should be smaller in size. Clearing a worksheet can be useful if data sets in a worksheet need to be replaced, i.e. data are first read, modified in R and finally written back to the worksheet. Without clearing the worksheet first, (parts of) the original data may still be visible if they occupied a larger range of the worksheet.
Nicola Lambiase
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
, clearNamedRegion
,
clearRange
,
clearRangeFromReference
## 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 worksheets named 'mtcars' and 'mtcars2' clearSheet(wb, sheet = c("mtcars", "mtcars2")) # Clear 3rd worksheet clearSheet(wb, sheet = 3) ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.