letter-num-conversion: Convert between letter and integer representations of column...

In cellranger: Translate Spreadsheet Cell Ranges to Rows and Columns

Description

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.

Usage

letter_to_num(x)

num_to_letter(y)

Arguments

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

Details

• 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).

Value

a vector of column IDs, either character or integer

Examples

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

Example output

[1] 26
[1]    27   702   732 18278
[1] NA NA
[1] "AB"
[1] "AHP"
[1] "ZZZ"
[1] "Y"   "AZ"  "AHP" "ZZZ"
[1] NA  NA  "D" NA 

cellranger documentation built on May 2, 2019, 11:26 a.m.