Excel行列解析算法

[bojue]

let getCols = (str) => {
  let arr = str.split('');
  let len = arr.length;
  let res = 0;
  for(let i=0;i<len;i++) {
      let item = arr[i];
      let curr = (item.charCodeAt(0) - 64) * Math.pow(26, (len -1 -i));
      res += curr;
  }
  return res;
}
let getParams = (str)=> {
  if(str === undefined || str === null) return;
  let arr = str.match(/(^[A-Z]+)([0-9]+$)/);
  let [, col, row] = arr;
  let obj = {
      col: getCols(col),
      row: row
  }
  return obj;
}

getParams('AA12'); // {col: 27, row: "12"}