get_excel_range: Converts Numbers into 'Excel' Ranges

In qol: Powerful 'SAS' Inspired Concepts for more Efficient Bigger Outputs

Converts Numbers into 'Excel' Ranges

Description

Converts a column number into the according letter to form a cell reference like it is used in 'Excel' (e.g "A1"). Also can compute a range from cell to cell (e.g. "A1:BY22").

Usage

get_excel_range(
  row = NULL,
  column = NULL,
  from_row = NULL,
  from_column = NULL,
  to_row = NULL,
  to_column = NULL
)

Arguments

row	Single row number.
column	Single column number.
from_row	Range start row.
from_column	Range start column.
to_row	Range end row.
to_column	Range end column.

Value

Returns a character with an 'Excel' range.

Examples

single_cell <- get_excel_range(row = 1, column = 6)
range       <- get_excel_range(from_row = 1, from_column = 6,
                                 to_row = 5,   to_column = 35)

qol documentation built on Dec. 14, 2025, 1:06 a.m.