openxlsx: convertFromExcelRef – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

convertFromExcelRef

Convert excel column name to integer index

Convert excel column name to integer index e.g. "J" to 10

convertFromExcelRef(col)

col

An excel column reference

convertFromExcelRef("DOG")
convertFromExcelRef("COW")

## numbers will be removed
convertFromExcelRef("R22")

Read, Write and Edit xlsx Files

v4.2.3

MIT + file LICENSE

Authors

Philipp Schauberger [aut, cre], Alexander Walker [aut], Luca Braglia [ctb], Joshua Sturm [ctb]

Initial release

2020-10-26