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")
Example output
[1] 3101
[1] 2441
[1] 18
openxlsx documentation built on May 30, 2017, 5:37 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
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")
|
Example output
[1] 3101
[1] 2441
[1] 18
openxlsx documentation built on May 30, 2017, 5:37 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
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.