Shift n from given alphabetical colname

Source: R/makeXlColAlphabet.r

This function is useful for output with openxlsx package.

shift_abc(abc, n_shift = 0L)

Arguments

abc

a character vector to be shifted.

n_shift

numbers to shift, Default: 0

Value

a character vector

Examples

shift_abc("a", n_shift = 3)        # D
#> [1] "D"
shift_abc(letters, n_shift = 3)    # D–AC
#>  [1] "D"  "E"  "F"  "G"  "H"  "I"  "J"  "K"  "L"  "M"  "N"  "O"  "P"  "Q"  "R" 
#> [16] "S"  "T"  "U"  "V"  "W"  "X"  "Y"  "Z"  "AA" "AB" "AC"
shift_abc(letters, n_shift = 1:26) # B–AZ. skipping ahead one by one.
#>  [1] "B"  "D"  "F"  "H"  "J"  "L"  "N"  "P"  "R"  "T"  "V"  "X"  "Z"  "AB" "AD"
#> [16] "AF" "AH" "AJ" "AL" "AN" "AP" "AR" "AT" "AV" "AX" "AZ"