Learn R Programming

reportRmd (version 0.1.0)

excelColLetters: Retrieve spreadsheet column letter-names from columns indices

Description

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

Usage

excelColLetters(columnIndices)

Value

a character vector corresponding to the spreadsheet column headings

Arguments

columnIndices

vector of integer column indices

Details

This is the inverse function of excelCol

Examples

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

Run the code above in your browser using DataLab