🚀

End of Year Sale: Use Coupon Code END2025 to Get Extra 25% Off.

05DAYS
:
14HOURS
:
37MINUTES
:
34SECONDS

Leetcode Problem 171. Excel Sheet Column Number

171. Excel Sheet Column Number

Leetcode Solutions

Base- to Base- Conversion

  1. Initialize a variable result to 0. This will hold the final column number.
  2. Iterate over each character in the columnTitle string from left to right.
  3. Convert the current character to its corresponding number (1-26) by subtracting the ASCII value of 'A' and adding 1.
  4. Multiply result by 26 (since we're moving to the next 'digit' in base-26) and add the number from step 3 to result.
  5. Continue this process until all characters have been processed.
  6. Return result as the final column number.
UML Thumbnail

Right to Left Base- to Base- Conversion

Ask Question

Programming Language
image/screenshot of info(optional)
Full Screen
Loading...

Suggested Answer

Answer
Full Screen
Copy Answer Code
Loading...