Commit984e54f

zongyanqi

committed

add Easy_171_Excel_Sheet_Column_Number

1 parent4f488e4 commit984e54fCopy full SHA for 984e54f

File tree

+31

-0

lines changed

+31

-0

lines changed

Lines changed: 31 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,31 @@`
	`1`	`+/**`
	`2`	`+ * Given a column title as appear in an Excel sheet, return its corresponding column number.`
	`3`	`+`
	`4`	`+ For example:`
	`5`	`+`
	`6`	`+ A -> 1`
	`7`	`+ B -> 2`
	`8`	`+ C -> 3`
	`9`	`+ ...`
	`10`	`+ Z -> 26`
	`11`	`+ AA -> 27`
	`12`	`+ AB -> 28`
	`13`	`+`
	`14`	`+ */`
	`15`	`+`
	`16`	`+/**`
	`17`	`+ *@param {string} s`
	`18`	`+ *@return {number}`
	`19`	`+ */`
	`20`	`+vartitleToNumber=function(s){`
	`21`	`+`
	`22`	`+varnum=0;`
	`23`	`+varaCode='A'.charCodeAt(0);`
	`24`	`+for(vari=0;i<s.length;i++){`
	`25`	`+varn=1+s.charCodeAt(i)-aCode;`
	`26`	`+num=num*26+n;`
	`27`	`+}`
	`28`	`+returnnum;`
	`29`	`+};`
	`30`	`+`
	`31`	`+console.log(titleToNumber('AA'));`

Comments

(0)