This application convert data between C1 style (Excel references for columns) and positional (starting at zero) style.
For instance:
| A1 ref | Is equivalent to position |
|---|---|
| A | 0 |
| K | 10 |
| AA | 26 |
| AZ | 51 |
The other direction is also covered:
| Position | Is equivalent to A1 ref |
|---|---|
| 25 | Z |
| 9 | J |
| 703 | AAB |
| 27 | AB |
Useful when working between Excel/CSV and Java positional referencing.
$ lein -uberjar
$ java -jar a1-positional-style-converter-0.1.0-standalone.jar [args]
- arg0: <pos|a1>
- arg1: <pos value|a1 value>
$ java -jar a1-positional-style-converter-0.1.0-standalone.jar a1 C
returns 2
$ java -jar a1-positional-style-converter-0.1.0-standalone.jar pos 10
returns K
Copyright © 2019 medeiros
Distributed under the MIT License.