FilesExpand file tree

 master

/

ExcelSheetColumnNumber.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

29 lines (26 loc) · 761 Bytes

 master

/

ExcelSheetColumnNumber.java

Copy path

Top

File metadata and controls

• Code
• Blame

29 lines (26 loc) · 761 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

package string;

/**

* Created by gouthamvidyapradhan on 07/07/2017. Given a column title as appear in an Excel sheet,

* return its corresponding column number.

*

* <p>For example:

*

* <p>A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28

*/

public class ExcelSheetColumnNumber {

String CONST = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

public static void main(String[] args) throws Exception {

System.out.println(new ExcelSheetColumnNumber().titleToNumber("AAB"));

}

public int titleToNumber(String s) {

int total = 0;

int j = 0;

for (int i = s.length() - 1; i >= 0; i--) {

char c = s.charAt(i);

int pos = CONST.indexOf(c) + 1;

int pow = (int) Math.pow(26, j++);

total += (pow * pos);

}

return total;

}

}