extractSheetName
From XLConnect v1.0.1
by Martin Studer
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.
Examples
# NOT RUN {
extractSheetName(c("MySheet!$A$1", "'My Sheet'!$A$1", "'My!Sheet'!$A$1"))
# }
Community examples
Looks like there are no examples yet.