Helper functions to work with dims — dims_helper • openxlsx2

Internal helpers to (de)construct a dims argument from/to a row and column vector. Exported for user convenience.

Usage

dims_to_rowcol(x, as_integer = FALSE)

rowcol_to_dims(row, col)

Arguments

x: a dimension object "A1" or "A1:A1"
as_integer: If the output should be returned as integer, (defaults to string)
row: a numeric vector of rows
col: a numeric or character vector of cols

Value

A dims string for _to_dim i.e "A1:A1"
A list of rows and columns for to_rowcol

See also

Examples

dims_to_rowcol("A1:J10")
#> [[1]]
#>  [1] "A" "B" "C" "D" "E" "F" "G" "H" "I" "J"
#> 
#> [[2]]
#>  [1] "1"  "2"  "3"  "4"  "5"  "6"  "7"  "8"  "9"  "10"
#> 
wb_dims(1:10, 1:10)
#> [1] "A1:J10"