removeName-methods

Removing names from workbooks

Removes a name from a '>workbook.

Usage

# S4 method for workbook
removeName(object,name)

Details

Removes the name named name from the specified workbook object if it does exist. Multiple names can be specified to be removed.

See Also

'>workbook, createName, existsName, getDefinedNames, readNamedRegion, writeNamedRegion

Aliases

• removeName
• removeName-methods
• removeName,workbook-method

Examples

# NOT RUN {
# mtcars xlsx file from demoFiles subfolder of package XLConnect
mtcarsFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")

# Load workbook
wb <- loadWorkbook(mtcarsFile)

# Remove the named region called 'mtcars' from the above file
# (this named region is defined as 'mtcars!$A$1:$K$33')
removeName(wb, name = "mtcars")
# }