Functions related to Excel

In thinkr: Tools for Cleaning Up Messy Files

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>"
)

library(thinkr)

excel_names : dealing with column names and position number

• ncol_to_excel() returns Excel column name from a position number.
• excel_to_ncol() returns Excel column position number from a column name.
• excel_col() returns all Excel column name.

ncol_to_excel(35)
excel_to_ncol("BF")
excel_col()
ncol_to_excel(1:6)
excel_to_ncol(c('AF', 'AG', 'AH'))

thinkr documentation built on Aug. 22, 2022, 5:05 p.m.