excel.link (version 0.9.4)

xl.index2address: Converts Excel address to indexes and vice versa.

Description

Converts Excel address to indexes and vice versa.

Usage

xl.index2address(top, left, bottom = NULL, right = NULL)
xl.address2index(str.range)

Arguments

top

integer top index of top-left cell

left

integer left index of top-left cell

bottom

integer bottom index of bottom-right cell

right

integer right index of bottom-right cell

str.range

character Excel range address

Value

xl.index2address returns character address (e. g. A1:B150), xl.address2index returns vector with four components: top, left, bottom, right.

Examples

xl.address2index("A1:D150")
xl.index2address(top=1, left=1)

## Not run: 
# a1 %=xl% a1
# a1 = iris
# addr = xl.binding.address(a1)$address
# xl.address2index(addr) 
# 
# ## End(Not run)