getDefinedNames-methods: Retrieving defined names in a workbook

Description Usage Arguments Author(s) See Also Examples

Description

Retrieves the defined names in a workbook.

Usage

1
2
## S4 method for signature 'workbook'
getDefinedNames(object, validOnly)

Arguments

object

The workbook to use

validOnly

If validOnly = TRUE only names with valid references are returned. Valid references are ones not starting with #REF! or #NULL! - which could result e.g. due to a missing sheet reference. The default value for validOnly is TRUE.

Author(s)

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

See Also

workbook, createName, removeName, existsName, readNamedRegion,
writeNamedRegion

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
## Not run: 
# mtcars xlsx file from demoFiles subfolder of package XLConnect
mtcarsFile <- system.file("demoFiles/mtcars.xlsx", package = "XLConnect")

# Load workbook
wb <- loadWorkbook(mtcarsFile)

# Retrieve defined names with valid references
getDefinedNames(wb)

## End(Not run)

XLConnect documentation built on April 11, 2021, 9:06 a.m.