Learn R Programming

openxlsx2 (version 1.22)

col2int: Convert spreadsheet column to integer

Description

Converts a spreadsheet column in A1 notation to an integer. "A" is 1, "B" is 2, ..., "Z" is 26 and "AA" is 27.

Usage

col2int(x)

Value

An integer column label (or NULL if x is NULL)

Arguments

x

A character vector

Examples

Run this code
col2int(LETTERS)

Run the code above in your browser using DataLab