getDefinedNames-methods

0th

Percentile

Retrieving defined names in a workbook

Retrieves the defined names in a '>workbook.

Keywords
methods, utilities
Usage
# S4 method for 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.

See Also

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

Aliases
  • getDefinedNames
  • getDefinedNames-methods
  • getDefinedNames,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)

# Retrieve defined names with valid references
getDefinedNames(wb)
# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.