convert column number to Excel column name
colNum2excelName(x, useLetters = LETTERS, zeroVal = "a", ...)integer vector
character vector of single-digit characters to use as
digits in the resulting column name. Note that these characters can
be of almost any length, with any content.
character single-digit to be used whenever x==0, or as a
prefix for negative values. In theory there should be no negative
input values, but this basic mechanism is used to handle the possibility.
character vector with length(x)
The purpose is to convert an integer column number into a valid Excel
column name, using LETTERS starting at A.
This function implements an arbitrary number of digits, which may or
may not be compatible with each version of Excel. 18,278 columns
would be the maximum for three digits, "A" through "ZZZ".
This function is useful when referencing Excel columns via another
interface such as via openxlsx. It is also used by makeNames()
when the numberStyle="letters", in order to provide letter suffix values.
One can somewhat manipulate the allowed column names via the useLetters
argument, which by default uses the entire 26-letter Western alphabet.
Other jam practical functions:
breakDensity(),
checkLightMode(),
check_pkg_installed(),
color_dither(),
diff_functions(),
exp2signed(),
fileInfo(),
fixYellow(),
getAxisLabel(),
handleArgsText(),
heads(),
isFALSEV(),
isTRUEV(),
jamba,
jargs(),
kable_coloring(),
lldf(),
log2signed(),
make_html_styles(),
make_styles(),
match_unique(),
mergeAllXY(),
middle(),
minorLogTicks(),
newestFile(),
printDebug(),
renameColumn(),
rmInfinite(),
rmNAs(),
rmNA(),
rmNULL(),
sclass(),
sdim(),
setPrompt()
colNum2excelName(1:30)
#> [1] "A" "B" "C" "D" "E" "F" "G" "H" "I" "J" "K" "L" "M" "N" "O"
#> [16] "P" "Q" "R" "S" "T" "U" "V" "W" "X" "Y" "Z" "AA" "AB" "AC" "AD"