createName-methods
Creating names in a workbook
Usage
# S4 method for workbook
createName(object, name, formula, overwrite)Arguments
- object
- name
The name's name to create
- formula
Excel formula specifying the name
- overwrite
If a name with the same
namealready exists andoverwrite = TRUE, then this name is removed first before the new one is created. If a name already exists andoverwrite = FALSE, then an exception is thrown. The default value foroverwriteisFALSE.
Details
Creates a name named name for the specified formula.
The formula should be specified as you would type it
in Excel. Make sure that the worksheets, functions, ...
exist that you are referring to in the formula.
The name, formula and overwrite arguments are
vectorized such that multiple names can be created in one method call.
References
What are named regions/ranges? http://www.officearticles.com/excel/named_ranges_in_microsoft_excel.htm How to create named regions/ranges? http://www.youtube.com/watch?v=iAE9a0uRtpM
See Also
'>workbook,
removeName,
existsName,
getDefinedNames,
readNamedRegion,
writeNamedRegion
Examples
# NOT RUN {
# Load workbook (create if not existing)
wb <- loadWorkbook("createName.xlsx", create = TRUE)
# Create a worksheet named 'mtcars'
createSheet(wb, name = "mtcars")
# Create a named region called 'mtcars' on the sheet called 'mtcars'
createName(wb, name = "mtcars", formula = "mtcars!$A$1")
# Write built-in data set 'mtcars' to the above defined named region
writeNamedRegion(wb, mtcars, name = "mtcars")
# Save workbook
saveWorkbook(wb)
# clean up
file.remove("createName.xlsx")
# }