extractSheetName

0th

Percentile

Extracting the sheet name from a formula

Extracts the sheet name from a formula of the form <SHEET_NAME>!<CELL_ADDRESS>

Keywords
utilities
Usage
extractSheetName(formula)
Arguments
formula

Formula string of the form <SHEET_NAME>!<CELL_ADDRESS>. Note that the validity of the formula won't be checked.

Value

Returns the name of the sheet referenced in the formula. For quoted sheet names (required if names contain e.g. whitespaces or exclamation marks (!)) in formulas the function returns the unquoted name.

Aliases
  • extractSheetName
Examples
# NOT RUN {
extractSheetName(c("MySheet!$A$1", "'My Sheet'!$A$1", "'My!Sheet'!$A$1"))
# }
Documentation reproduced from package XLConnect, version 0.2-14, License: GPL-3

Community examples

Looks like there are no examples yet.