letter-num-conversion: Convert between letter and integer representations of column...
In jennybc/cellranger: Translate Spreadsheet Cell Ranges to Rows and Columns

Description Usage Arguments Details Value Examples

Convert "A1"-style column IDs from a letter representation to an integer, e.g. column A becomes 1, column D becomes 4, etc. Or go the other way around.

1
2
3

letter_to_num(x)

num_to_letter(y)

`x`	a character vector of "A1" style column IDs (case insensitive)
`y`	a vector of integer column IDs

Google Sheets have up to 300 columns (column KN).
Excel 2010 spreadsheets have up to 16,384 columns (column XFD).
ZZ is column 702.
ZZZ is column 18,278 (no known spreadsheet actually goes that high).

a vector of column IDs, either character or integer

letter_to_num('Z')
letter_to_num(c('AA', 'ZZ', 'ABD', 'ZZZ'))
letter_to_num(c(NA, ''))
num_to_letter(28)
num_to_letter(900)
num_to_letter(18278)
num_to_letter(c(25, 52, 900, 18278))
num_to_letter(c(NA, 0, 4.8, -4))