Excel 表列序号

与Excel 表列名称相反。

进制转换

function titleToNumber(columnTitle: string): number {
  const baseNum = 'A'.charCodeAt(0)
  let num = 0

  for (let i = 0; i < columnTitle.length; i++) {
    const cur = columnTitle.charCodeAt(i)
    num = num * 26 + (cur - baseNum + 1)
  }

  return num
}