Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

getCellRefs

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

Read, Write and Edit xlsx Files

v4.2.3
MIT + file LICENSE
Authors
Philipp Schauberger [aut, cre], Alexander Walker [aut], Luca Braglia [ctb], Joshua Sturm [ctb]
Initial release
2020-10-26

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.