EASY/src/easy/ExcelSheetColumnNumber.java

fishercoder1534 · fishercoder1534 · commit 662b166d3259 · 2016-09-24T17:41:01.000-07:00
diff --git a/EASY/src/easy/ExcelSheetColumnNumber.java b/EASY/src/easy/ExcelSheetColumnNumber.java
@@ -0,0 +1,20 @@
+package easy;
+
+public class ExcelSheetColumnNumber {
+
+    public static int titleToNumber(String s) {
+        char[] c = s.toCharArray();
+        int result = 0;
+        for(int i = s.length()-1; i >= 0; i--){
+            result += (c[i]-64)* ((int) Math.pow(26, s.length()-i-1));
+        }
+        
+        return result;
+    }
+    
+    public static void main(String...strings){
+        String s = "AB";
+        System.out.println(titleToNumber(s));
+    }
+
+}
