makeXlColAlphabet: Make Microsoft Excel's alphabetical column names

In JK-junkin/frabento: FRAgmentary BENri TOols

Make Microsoft Excel's alphabetical column names

Description

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

Usage

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.

Details

No description.

Value

A character vector.

See Also

shift_abc make_abcbase index2abc abc2index

Examples

makeXlColAlphabet()
makeXlColAlphabet(nchar = 1)
makeXlColAlphabet(start = "B", len = length(1978:2020))
makeXlColAlphabet(start = 23, len = 10, print_all = TRUE)

JK-junkin/frabento documentation built on Oct. 20, 2023, noon