colname_from_colnumber: Spreadsheet column name from number

In jomuller/vartors: Transform Definition of Variables to R Scripts

Description

Convert an integer number to the equivalent column name in a spreadsheet. This is an helper function used internaly in descvars_skeleton to generate the variable column. For example, column 28 is "AB".

Usage

colname_from_colnumber(colnumber)

Arguments

colnumber

An integer. The number of the column.

Note

This function have a bug : colname_from_colnumber(53) give AA instead of BA. The bug is listed in the bugtracking system as the issue 59 and will be fixed in a further version.

Author(s)

Joris Muller

Examples

colname_from_colnumber(3)
# "C"
colname_from_colnumber(27)
# "AA"
colname_from_colnumber(666)
# "XP"

jomuller/vartors documentation built on May 19, 2019, 7:26 p.m.