# aref2idx

From XLConnect v1.0.1
by Martin Studer

##### Converting Excel cell references to row and column based cell references

Converts Excel cell references to row and column based cell references

- Keywords
- utilities

##### Usage

`aref2idx(x)`

##### Arguments

- x
`Character`

vector of Excel cell references (e.g. "A1:B6", "B6:C17", ...)

##### Value

Returns a numeric matrix with four columns and as many rows as cell references that have been provided. The first two columns represent the coordinates of the top left corner (row, column) and the third and fourth columns represent the bottom right corner of the referenced area.

##### See Also

##### Examples

```
# NOT RUN {
aref2idx(c("A1:B6", "B6:C17"))
# }
```

*Documentation reproduced from package XLConnect, version 1.0.1, License: GPL-3*

### Community examples

Looks like there are no examples yet.