Learn R Programming

openxlsx2 (version 0.7)

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

Description

Return excel cell coordinates from (x,y) coordinates

Usage

get_cell_refs(cellCoords)

Value

Excel alphanumeric cell reference

Arguments

cellCoords

A data.frame with two columns coordinate pairs.

Examples

Run this code
get_cell_refs(data.frame(1, 2))
# "B1"
get_cell_refs(data.frame(1:3, 2:4))
# "B1" "C2" "D3"

Run the code above in your browser using DataLab