cel2num: Convert Excel cell index to numeric column and row indexes

In tianqingliu/cel2num: Convert Excel cell index to numeric column and row indexes

Description

This function converts an Execl cell index (with max 2 column letters) to row and column numbers.

Usage

cel2num(celIndex, rrw = 0, rcn = 0)

Arguments

celIndex	with maxmum 2-letter column and a number, e.g. Ad23.
rrw	a (+/-) integer relative to celIndex row, defaults to 0.
rcn	a (+/-) integer relative to celIndex column, defaults to 0.

Value

The number of row with cel2num(...)$r or cel2num(...)[1], and the number of column with cel2num(...)#c or cel2num(...)[2].

Examples

cel2num("mD263")$r or cel2num("mD263")[1] for row number
cel2num("mD263")$c or cel2num("mD263")[2] for column number

tianqingliu/cel2num documentation built on May 8, 2019, 2:34 a.m.