colNum2excelName: convert column number to Excel column name

In jmw86069/jamba: Jam Base Methods

convert column number to Excel column name

Description

convert column number to Excel column name

Usage

colNum2excelName(x, useLetters = LETTERS, zeroVal = "a", ...)

Arguments

x	integer vector
useLetters	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.
zeroVal	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.

Details

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.

Value

character vector with length(x)

See Also

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()

Examples

colNum2excelName(1:30)

jmw86069/jamba documentation built on Oct. 9, 2024, 10:52 a.m.