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 | 3340 Views, 24253 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 | 3340 Views, 24253 Search Bots | 80 Words Subscribe to Feed Burner

Related Articles

  1. Daily Interview Puzzle: Falling Dominoes
  2. Staying on a Chess Board
  3. Algorithm Interview: Permutations of numbers
  4. Skip the readings, focus on problems. And use all the hints!
  5. Daily Interview Puzzle: Intersection of Linked Lists
  6. ImageMagick Vulnerabilities -  CVE-2016–3714
  7. Linode Support Ticket 10029540 - Other - Important Notice Regarding Ubuntu 17.10 Image
  8. Fix Brackets
  9. Algorithm Interview: Shifted String
  10. Spreadsheet Column Title

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" />