Add conditional formatting to cells
convertFromExcelRef: Convert excel column name to integer index
In openxlsx: Read, Write and Edit XLSX Files
Description
Usage
Arguments
Examples
Description
Convert excel column name to integer index e.g. "J" to 10
Usage
1
Arguments
col
An excel column reference
Examples
1
2
3
4
5
convertFromExcelRef("DOG")
convertFromExcelRef("COW")
## numbers will be removed
convertFromExcelRef("R22")
openxlsx documentation built on May 30, 2017, 5:37 a.m.
Search within the openxlsx package
Search all R packages, documentation and source code
R Package Documentation
Browse R Packages
We want your feedback!
Description Usage Arguments Examples
Description
Convert excel column name to integer index e.g. "J" to 10
Usage
1 |
Arguments
col |
An excel column reference |
Examples
1 2 3 4 5 | convertFromExcelRef("DOG")
convertFromExcelRef("COW")
## numbers will be removed
convertFromExcelRef("R22")
|
Search within the openxlsx package
Search all R packages, documentation and source code
R Package Documentation
Browse R Packages
We want your feedback!
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.