removeName-methods: Removing names from workbooks

In miraisolutions/xlconnect: Excel Connector for R

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)

miraisolutions/xlconnect documentation built on April 19, 2024, 2:40 p.m.