2022/12/20

LeetCode 2194. Cells in a Range on an Excel Sheet

問題:輸出Cells in a Range
解法:先取得欄位開始名稱與結束名稱,接著跑for迴圈並將值塞入陣列,回傳 
 JavaScript
/**
 * @param {string} s
 * @return {string[]}
 */
var cellsInRange = function (s) {
    let splitArray = s.split(":");
    let startChar = splitArray[0].charCodeAt(0);
    let startNum = parseInt(splitArray[0].replace(String.fromCharCode(startChar), ""));
    const endChar = splitArray[1].charCodeAt(0);
    const endNum = parseInt(splitArray[1].replace(String.fromCharCode(endChar), ""));

    let temp = [];
    for (; startChar <= endChar; startChar++) {
        const s = String.fromCharCode(startChar);
        for (let i = startNum; i <= endNum; i++) {
            temp.push(s + i);
        }
    }

    return temp;
};