excelColLetters {reportRmd}

Retrieve spreadsheet column letter-names from columns indices

Description

Creates a vector of spreadsheet-style letter-names corresponding to column numbers

Usage

excelColLetters(columnIndices)

Arguments

columnIndices

vector of integer column indices

Details

This is the inverse function of excelCol

Value

a character vector corresponding to the spreadsheet column headings

Examples

## Find the column numbers for excel columns AB, CE and BB
colIndices <- excelCol(AB,CE,bb)
## Go back to the column names
excelColLetters(colIndices)