To the Top
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 | 3349 Views, 25237 Search Bots | 80 Words

Subscribe to Feed Burner | Browse | Archive
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.


def column_name(n):
# Fill this in.

print column_name(26)
print column_name(27)
print column_name(28)
# Z
# AA
# AB
Tags: 每日算法题, 算法, 数据结构, 面试题, Daily Interview Problem, Data Structures and Algorithms, Computer Programming, Python, | English | Home Page | Cateogry: Computing | 3349 Views, 25237 Search Bots | 80 Words Subscribe to Feed Burner

Related Articles

  1. Daily Interview Question: Longest Sequence with Two Unique Numbers
  2. Skip the readings, focus on problems. And use all the hints!
  3. Generate All IP Addresses
  4. First and Last Indices of an Element in a Sorted Array
  5. Algorithm Interview: String Compression
  6. Invert a Binary Tree
  7. [Daily Problem] Longest Palindromic Substring
  8. Algorithm Interview: Permutations of numbers
  9. Daily Interview Problem: Min Range Needed to Sort
  10. Algorithm Interview: Lowest Common Ancestor of 2 Nodes in Binary Tree

Comments (0)

    Be the first one to comment this page !


Page Edited: May 11 2024 14:36:49 | RSS Subscription
How to Cook a Perfect Steak? | <meta name="robots" content="noindex, follow" />