摘要:進(jìn)制復(fù)雜度時(shí)間空間思路得到數(shù)字,其實(shí)就是把進(jìn)制的數(shù)轉(zhuǎn)換為進(jìn)制的數(shù)。算法就是基本的進(jìn)制轉(zhuǎn)換方法,從后往前第位的值乘上。不過因?yàn)槭牵皇?,相?dāng)于進(jìn)制的數(shù)都整體減,才能對(duì)應(yīng)上從開始的十進(jìn)制數(shù)。
Excel Sheet Column Number
26進(jìn)制 復(fù)雜度Related to question Excel Sheet Column Title
Given a column title as appear in an Excel sheet, return its corresponding column number.
For example:
A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28
時(shí)間 O(N) 空間 O(1)
思路得到數(shù)字,其實(shí)就是把26進(jìn)制的數(shù)轉(zhuǎn)換為10進(jìn)制的數(shù)。算法就是基本的進(jìn)制轉(zhuǎn)換方法,從后往前第n位的值乘上26^(n-1)。這里26進(jìn)制數(shù)是1開始的,即A是1。
代碼public class Solution { public int titleToNumber(String s) { int num = 0, pow = 1; for(int i = s.length() - 1; i >= 0 ; i--){ num += (s.charAt(i) - "A" + 1)*pow; pow *= 26; } return num; } }Excel Sheet Column Title
26進(jìn)制 復(fù)雜度Given a positive integer, return its corresponding column title as appear in an Excel sheet.
For example:
1 -> A 2 -> B 3 -> C ... 26 -> Z 27 -> AA 28 -> AB
時(shí)間 O(N) 空間 O(1)
思路把10進(jìn)制的轉(zhuǎn)換成26進(jìn)制,做法是除26取余,一直除到0,最后把余數(shù)逆序一下就行了。不過因?yàn)锳是1,而不是0,相當(dāng)于26進(jìn)制的數(shù)都整體減1,才能對(duì)應(yīng)上從0開始的十進(jìn)制數(shù)。
代碼public class Solution { public String convertToTitle(int n) { StringBuilder sb = new StringBuilder(); while(n != 0){ sb.append((char)("A" + (n - 1) % 26)); n = (n - 1) / 26; } return sb.reverse().toString(); } }
文章版權(quán)歸作者所有,未經(jīng)允許請(qǐng)勿轉(zhuǎn)載,若此文章存在違規(guī)行為,您可以聯(lián)系管理員刪除。
轉(zhuǎn)載請(qǐng)注明本文地址:http://www.ezyhdfw.cn/yun/64699.html
Problem Given a column title as appear in an Excel sheet, return its corresponding column number. For example: A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28 ... Example 1: Input: A Output: 1 Exa...
Problem Given a column title as appear in an Excel sheet, return its corresponding column number. For example: A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28 Solution ...
Problem Given a positive integer, return its corresponding column title as appear in an Excel sheet. For example: 1 -> A 2 -> B 3 -> C ... 26 -> Z 27 -> AA 28 -> AB ... Example 1: Input: 1Output: AEx...
摘要:微信公眾號(hào)記錄截圖記錄截圖目前關(guān)于這塊算法與數(shù)據(jù)結(jié)構(gòu)的安排前。已攻略返回目錄目前已攻略篇文章。會(huì)根據(jù)題解以及留言內(nèi)容,進(jìn)行補(bǔ)充,并添加上提供題解的小伙伴的昵稱和地址。本許可協(xié)議授權(quán)之外的使用權(quán)限可以從處獲得。 Create by jsliang on 2019-07-15 11:54:45 Recently revised in 2019-07-15 15:25:25 一 目錄 不...
Problem Related to question Excel Sheet Column Title Given a column title as appear in an Excel sheet, return its corresponding column number. Example A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 2...
閱讀 2494·2021-10-09 09:59
閱讀 2274·2021-09-23 11:30
閱讀 2665·2019-08-30 15:56
閱讀 1208·2019-08-30 14:00
閱讀 3007·2019-08-29 12:37
閱讀 1329·2019-08-28 18:16
閱讀 1714·2019-08-27 10:56
閱讀 1087·2019-08-26 17:23