File: root - text - article - 2020 - 02 - spreadsheet-columns.txt
Tags: 每日算法题, 算法, 数据结构, 面试题, Daily Interview Problem, Data Structures and Algorithms, Computer Programming, Python, | English | Home Page | Category: Computing | 3509 Views, 26314 Search Bots | 80 Words
| Browse | Archive
![Subscribe to Feed Burner Subscribe to Feed Burner](/images/form/rss.gif)
Tags: 每日算法题, 算法, 数据结构, 面试题, Daily Interview Problem, Data Structures and Algorithms, Computer Programming, Python, | English | Home Page | Category: Computing | 3509 Views, 26314 Search Bots | 80 Words
![Subscribe to Feed Burner Subscribe to Feed Burner](/images/form/rss.gif)
Hi, here's your problem today. This problem was recently asked by Apple:
In many spreadsheet applications, the columns are marked with letters. From the 1st to the 26th column the letters are A to Z. Then starting from the 27th column it uses AA, AB, ..., ZZ, AAA, etc.
Given a number n, find the n-th column name.
Tags: 每日算法题, 算法, 数据结构, 面试题, Daily Interview Problem, Data Structures and Algorithms, Computer Programming, Python, | English | Home Page | Cateogry: Computing | 3509 Views, 26314 Search Bots | 80 Words In many spreadsheet applications, the columns are marked with letters. From the 1st to the 26th column the letters are A to Z. Then starting from the 27th column it uses AA, AB, ..., ZZ, AAA, etc.
Given a number n, find the n-th column name.
def column_name(n):
# Fill this in.
print column_name(26)
print column_name(27)
print column_name(28)
# Z
# AA
# AB
![Subscribe to Feed Burner Subscribe to Feed Burner](/images/form/rss.gif)
Related Articles
- Find the non-duplicate number
- Algorithm Interview: No Adjacent Repeating Characters
- Algorithm Interview Question: Max and Min with Limited Comparisons
- Plus One
- Daily Interview Problem: Group Words that are Anagrams
- [Daily Problem] Validate Balanced Parentheses
- Daily Interview Problem: Circle of Chained Words
- Spreadsheet Column Title
- Daily Interview Problem: Given two arrays, write a function to compute their intersection.
- Generate All IP Addresses
©2006~2024 SteakOverCooked - 0.00968 Seconds(s) - 1944.248 KB/s - 9 Online
Memory: 492.34 KB
18:54:01 up 13 days, 18:33, 2 users, load average: 0.98, 0.86, 0.73 - Server PHP Version: 7.4.33
How to Cook a Perfect Steak? | <meta name="robots" content="noindex, follow" />
![](/images/top.jpg)
18:54:01 up 13 days, 18:33, 2 users, load average: 0.98, 0.86, 0.73 - Server PHP Version: 7.4.33
Read & Write - Normal - Mini - Post - All Comments - Statistics
Be the first one to comment this page !