removeName-methods {XLConnect}

Removing names from workbooks

Description

Removes a name from a workbook.

Usage

## S4 method for signature 'workbook'
removeName(object,name)

Arguments

object

The workbook to use

name

The name to delete

Details

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

Author(s)

Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch

See Also

workbook, createName, existsName,
getDefinedNames, readNamedRegion, writeNamedRegion

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")

## End(Not run)