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

Related Articles

  1. Windows Scripting
  2. Daily Interview Problem: Largest Product of 3 Elements I
  3. Daily Interview Problem: Given two arrays, write a function to compute their intersection.
  4. Daily Interview Problem: 3 Sum
  5. Daily Interview Problem: Count Number of Unival Subtrees
  6. Consecutive Ones
  7. Spreadsheet Column Title
  8. Autorun.inf Virus Protection
  9. Generate All IP Addresses
  10. Detect Linked List Cycle

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