Converts Excel column name Letter to One Based Index Number(e.g. A->1 AB->28) Install npm i excel-column-letter-2-number Converts let excelCol2Num = require('excel-column-letter-2-number').excelCol2Num console.log(excelCol2Num("AB"));//28