excel_names {thinkr}

Get position or excel name of column

Description

ncol_to_excel returns excel column name from a position number. excel_to_ncol returns excel column position number from a column name. excel_col returns all excel column name.

Usage

ncol_to_excel(n)

excel_to_ncol(col_name)

excel_col()

Arguments

n

the column position

col_name

the culumn name

Examples

ncol_to_excel(35)
excel_to_ncol("BF")
excel_col()
ncol_to_excel(1:6)
excel_to_ncol(c('AF', 'AG', 'AH'))