Make Microsoft Excel's alphabetical column names

Genarate a character vector such as "A" "B" ... "AA" "AB" ... "ZZZ".

makeXlColAlphabet(start = NULL, len = NULL, nchar = 2L, print_all = FALSE)

Arguments

start

Index or character at start, Default: NULL (to which 'A' is automatically assigned). start larger than len will return NA.

len

Length (size) of the output vector, Default: NULL

nchar

A number of combined characters, Default: 2

print_all

displays all characters to the console if TRUE. When FALSE (default), showing only the first and last characters with column numbers.

Value

A character vector.

Details

No description.

See also

shift_abc make_abcbase index2abc abc2index

Examples

makeXlColAlphabet()
#>    1  702 
#>  "A" "ZZ" 
makeXlColAlphabet(nchar = 1)
#>   1  26 
#> "A" "Z" 
makeXlColAlphabet(start = "B", len = length(1978:2020))
#>    2   44 
#>  "B" "AR" 
makeXlColAlphabet(start = 23, len = 10, print_all = TRUE)
#>  [1] "W"  "X"  "Y"  "Z"  "AA" "AB" "AC" "AD" "AE" "AF"