getCellRefs: Return excel cell coordinates from (x,y) coordinates

View source: R/wrappers.R

getCellRefsR Documentation

Return excel cell coordinates from (x,y) coordinates

Description

Return excel cell coordinates from (x,y) coordinates

Usage

getCellRefs(cellCoords)

Arguments

cellCoords

A data.frame with two columns coordinate pairs.

Value

Excel alphanumeric cell reference

Author(s)

Philipp Schauberger, Alexander Walker

Examples

getCellRefs(data.frame(1, 2))
# "B1"
getCellRefs(data.frame(1:3, 2:4))
# "B1" "C2" "D3"

openxlsx documentation built on Feb. 16, 2023, 6:47 p.m.