Excel Column Number

Undefined

English

The mission is in Blocked Mode. Access to the solutions is blocked for a day or two (even after you share your own), until we'll have enough solutions for you to check. All users who've solved the mission will get the notifications about their opening.

Given a string that represents the column title as appear in an Excel sheet, return its corresponding column number.

Input: String.

Output: Int.

Example:

assert column_number("A") == 1
assert column_number("Z") == 26
assert column_number("AB") == 28
assert column_number("ZY") == 701

Precondition: Non empty, only upper case, only English letters

by:

oduvan

Rating: 3 Login to vote

Solve as a guest
Sign in to your account

Settings

Code:

Auto close brackets and quotes
Auto scroll to the best solutions after successful check
Do not show the best solutions (but those are still available after "View All Solutions" button)
Highlight the same word

Save & Reload Close

CheckiO Extensions

CheckiO Extensions allow you to use local files to solve missions. More info in a blog post.

In order to install CheckiO client you'll need installed Python (version at least 3.8)

Install CheckiO Client first:

pip3 install checkio_client

Configure your tool

checkio --domain=py config --key=

Sync solutions into your local folder

checkio sync

(in beta testing) Launch local server so your browser can use it and sync solution between local file end extension on the fly. (doesn't work for safari)