excel.link (version 0.9.13)

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)

Value

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

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

Examples

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

if (FALSE) {
a1 %=xl% a1
a1 = iris
addr = xl.binding.address(a1)$address
xl.address2index(addr) 

}