{"id":26137,"date":"2017-10-26T20:03:53","date_gmt":"2017-10-26T14:33:53","guid":{"rendered":"https:\/\/www.wikitechy.com\/technology\/?p=26137"},"modified":"2017-10-26T20:03:53","modified_gmt":"2017-10-26T14:33:53","slug":"python-programming-excel-column-name","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/technology\/python-programming-excel-column-name\/","title":{"rendered":"Python Programming – Excel column name"},"content":{"rendered":"

MS Excel columns has a pattern like A, B, C, \u2026 ,Z, AA, AB, AC,\u2026. ,AZ, BA, BB, \u2026 ZZ, AAA, AAB \u2026.. etc. In other words, column 1 is named as \u201cA\u201d, column 2 as \u201cB\u201d, column 27 as \u201cAA\u201d.<\/span><\/p>\n

Given a column number, find its corresponding Excel column name. Following are more examples.<\/p>\n

Input          Output\r\n 26             Z\r\n 51             AY\r\n 52             AZ\r\n 80             CB\r\n 676            YZ\r\n 702            ZZ\r\n 705            AAC<\/pre>\n
Suppose we have a number n, let\u2019s say 28. so corresponding to it we need to print the column name. We need to take remainder with 26.<\/p>\n
If remainder with 26 comes out to be 0 (meaning 26, 52 and so on) then we put \u2018Z\u2019 in the output string and new n becomes n\/26 -1 because here we are considering 26 to be \u2018Z\u2019 while in actual it\u2019s 25th with respect to \u2018A\u2019.<\/p>\n
Similarly if the remainder comes out to be non zero. (like 1, 2, 3 and so on) then we need to just insert the char accordingly in the string and do n = n\/26.<\/p>\n
Finally we reverse the string and print.<\/p>\n[ad type=”banner”]\n
Example:<\/strong>
\nn = 700<\/p>\n
Remainder (n%26) is 24. So we put \u2018X\u2019 in output string and n becomes n\/26 which is 26.<\/p>\n
Remainder (26%26) is 0. So we put \u2018Z\u2019 in output string and n becomes n\/26 -1 which is 0.<\/p>\n
Following is python implementation of above approach.<\/p>\n
 
 Python Program<\/span> <\/div> 
# Python program to find Excel column name from a # given column number MAX = 50 # Function to print Excel column name for a given column numberdef printString(n):     # To store result (Excel column name)    string = ["\\0"]*MAX     # To store current index in str which is result    i = 0     while n > 0:        # Find remainder        rem = n%26         # if remainder is 0, then a 'Z' must be there in output        if rem == 0:            string[i] = 'Z'            i += 1            n = (n\/26)-1        else:            string[i] = chr((rem-1) + ord('A'))            i += 1            n = n\/26    string[i] = '\\0'     # Reverse the string and print result    string = string[::-1]    print "".join(string) # Driver program to test the above FunctionprintString(26)printString(51)printString(52)printString(80)printString(676)printString(702)printString(705)<\/code><\/pre> <\/div>\n
Output<\/strong><\/p>\n
Z\r\nAY\r\nAZ\r\nCB\r\nYZ\r\nZZ\r\nAAC<\/pre>\n[ad type=”banner”]\n","protected":false},"excerpt":{"rendered":"
Python Programming – Excel column name – Mathematical Algorithms – MS Excel columns has a pattern like A, B, C, \u2026 ,Z, AA, AB, AC,\u2026. ,AZ, BA, BB, \u2026 ZZ, AAA<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69969,1,74058,4148],"tags":[77308,77342,77340,77329,77299,77341,77278,77310,77305,77309,77337,77324,77335,77307,77346,77351,77312,77320,77315,77321,77344,77327,77350,77334,77333,77322,77345,77348,77343,77306,77347,77330,77323,77349,77316,77332,77317,77339,77319,77313,77311,77331,77326,77318,77338,77336,77304,77314,77325,77328],"class_list":["post-26137","post","type-post","status-publish","format-standard","hentry","category-algorithm","category-coding","category-mathematical-algorithms","category-python","tag-colt-python","tag-excel-auto-number","tag-excel-python","tag-excel-python-tutorial","tag-excel-sheet-column-number","tag-excel-sheet-column-number-leetcode","tag-excel-worksheet-columns","tag-how-to-import-data-in-python","tag-how-to-parse-excel-file-in-python","tag-how-to-read-data-from-excel-file-in-python","tag-how-to-read-excel-file-in-python","tag-open-excel-in-python","tag-openpyxl-python","tag-openpyxl-tutorial","tag-pandas-create-dataframe","tag-pandas-excel","tag-pandas-excel-tutorial","tag-pandas-excelwriter","tag-pandas-table","tag-pandas-xlsx","tag-python-cell","tag-python-convert-excel-to-csv","tag-python-csv-file","tag-python-csv-writer","tag-python-excel","tag-python-excel-api","tag-python-excel-example","tag-python-excel-library","tag-python-excel-module","tag-python-excel-tutorial","tag-python-for-excel","tag-python-import-xls","tag-python-library-for-excel","tag-python-openpyxl","tag-python-openpyxl-tutorial","tag-python-pandas","tag-python-parse-text-file-to-csv","tag-python-read-excel","tag-python-to-excel","tag-python-workbook","tag-python-xlrd-examples","tag-python-xlrd-read-column","tag-python-xlrd-tutorial","tag-python-xls-parser","tag-python-xlsx","tag-read-excel","tag-read-file-in-python","tag-workbook-python","tag-xlrd","tag-xlrd-python-tutorial"],"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/technology\/wp-json\/wp\/v2\/posts\/26137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/technology\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/technology\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/technology\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/technology\/wp-json\/wp\/v2\/comments?post=26137"}],"version-history":[{"count":0,"href":"https:\/\/www.wikitechy.com\/technology\/wp-json\/wp\/v2\/posts\/26137\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/technology\/wp-json\/wp\/v2\/media?parent=26137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/technology\/wp-json\/wp\/v2\/categories?post=26137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/technology\/wp-json\/wp\/v2\/tags?post=26137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}