col2int: Convert spreadsheet column to integer

In openxlsx2: Read, Write and Edit 'xlsx' Files

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)

Arguments

x	A character vector

Value

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

Examples

col2int(LETTERS)

openxlsx2 documentation built on Jan. 16, 2026, 5:06 p.m.