Daily-coding-/Excelsheet.java at main · Harshith2401/Daily-coding- · GitHub

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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
/*
Code
Testcase
Testcase
Test Result
171. Excel Sheet Column Number
Solved
Easy
Topics
premium lock icon
Companies
Given a string columnTitle that represents the column title as appears in an Excel sheet, return its corresponding column number.

For example:

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


Example 1:

Input: columnTitle = "A"
Output: 1
Example 2:

Input: columnTitle = "AB"
Output: 28
Example 3:

Input: columnTitle = "ZY"
Output: 701


Constraints:

1 <= columnTitle.length <= 7
columnTitle consists only of uppercase English letters.
columnTitle is in the range ["A", "FXSHRXW"]. */

class Solution {
    public int titleToNumber(String columnTitle) {
        int result=0;
        int pow=1;
        for(int i=columnTitle.length()-1;i>=0;i--)
        {
            int val=(int)columnTitle.charAt(i)-64;
            result=result+val*pow;
            pow=pow*26;

        }
        return result;

    }
}


class Solution {
    public int titleToNumber(String columnTitle) {
        int result=0;
        int pow=1;
        for(int i=columnTitle.length()-1;i>=0;i--)
        {
            int val=(int)columnTitle.charAt(i)-64;
            result=result+val*pow;
            pow=pow*26;

        }
        return result;

    }
}