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

Description Usage Arguments Value Examples

View source: R/address2index.R

Description

Converts Excel address to indexes and vice versa.

Usage

1
2
3
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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
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)

gdemin/excel.link documentation built on May 24, 2018, 9:31 p.m.