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

In excel.link: Convenient Data Exchange with Microsoft Excel

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)

excel.link documentation built on May 31, 2023, 5:27 p.m.