Cells in a Range on an Excel Sheet

EasyString

Solution

export function cellsInRange(s: string): string[] {
  function parse(s: string) {
    const [r, c] = [...s];
    return [r.charCodeAt(0), parseInt(c, 10)];
  }
 
  const [start, end] = s.split(':');
  const [r1, c1] = parse(start);
  const [r2, c2] = parse(end);
 
  const answer: string[] = [];
  for (let r = r1; r <= r2; r++) {
    for (let c = c1; c <= c2; c++) {
      answer.push(`${String.fromCharCode(r)}${c}`);
    }
  }
  return answer;
}