Classes with Excel Script Lab

$("#run").on("click", () => tryCatch(run));
async function run() {
await Excel.run(async (context) => {
const sheet = context.workbook.worksheets.getActiveWorksheet();
const mat = sheet.getRange("b2").getSurroundingRegion()
mat.load("rowCount,values,formulas,address")
await context.sync()
let matv = mat.values
const lastc = mat.getLastCell()
lastc.load("values,address")
await context.sync()
var rn = 10
var fs: string = ""
class adult {
  protected sheet2 = sheet
  action1() {
  sheet.getRange("b" + rn).values = [["Action1: " + lastc.address]]
  rn++
  lastc.values = matv[1][0]
  }
}
class woman extends adult {
  public esp = 2
  protected p = 3       // class and subclass
  protected static readonly vans = matv[3][3]
  action2() {
  const v: number = matv[4][2]
  this.sheet2.getRange("b" + rn).values = [["Action2: " + matv[2][2] + matv[3][2] + v + " at " + this.sheet2.name]]
  rn++
  this.sheet2.getRange("b" + matv[5][0]).values = [[100]]
  }
}
const tc = new woman()
let uni = mat.getResizedRange(-2, -3).getLastCell()
uni.values = [[300]]
sheet.load("values,name")
await context.sync()
matv[1][0] > matv[2][0] ? tc.action1() : tc.action2()
let Lv = matv[1][0]
sheet.getRange("b" + rn).values = [[JSON.stringify(Lv, null, 4)]]
rn++
// *************
class GT {
  private vals: number[] = []      // only for this class
  addg(...var4: number[]) {
  this.vals.push(...var4)
  return this.vals.length
  }
}
class GC {
  countg(s2: string[], one: string) {
  return s2.filter(val => val === one).length
  }
}
class FC extends GC {
  countg2(sa: string[]) {
  return super.countg(sa, Lv)
  }
}
const fv = new GT()
sheet.getRange("b" + rn).values = [["Row count is " + mat.rowCount]]
rn++
var td: number[] = []
for (let i = 0; i < mat.rowCount; i++) {
td.push(matv[i][2])
}
let av = fv.addg(...td)
sheet.getRange("b" + rn).values = [["length is " + av]]
rn++
const counter = new FC()
td = []
var tds: string[] = []
for (let i = 0; i < mat.rowCount; i++) {
tds.push(matv[i][3])
}
const count = counter.countg2(tds)
sheet.getRange("b" + rn).values = [["count is: " + count]]
rn++
class line {
  nocheck: string[]
  init(pend: string[]) {
  this.nocheck = pend
  }
  proceed() {
  return this.nocheck.pop()
  }
}
const acts = new line()
tds = []
for (let i = 0; i < mat.rowCount; i++) {
tds.push(matv[i][4])
}
acts.init(tds)
sheet.getRange("b" + rn).values = [["next is " + acts.proceed()]]
rn++
class SB {
  getval() {
  return [matv[1][5], matv[0][5]]
  }
}
function useSB(veh: SB) {
fs = "getval length is " + veh.getval().length
}
const sbv=new SB
const res=sbv.getval()
//console.log(res.length)   // result is 2
useSB({ getval: () => matv[2][5] })
sheet.getRange("b" + rn).values = [[fs]]
rn++
interface child {
name: string; eval(hours: number): void
}
fs = ""
class foreign implements child {
  name: string
  constructor(name2: string) {
  this.name = name2
  }
  eval(measure: number): void {
  for (let i = 0; i < measure; i += 1) {
  fs = fs + bel.name + i + "/"
  }
  }
}
const bel = new foreign(matv[1][6])
bel.eval(2)
sheet.getRange("b" + rn).values = [[fs]]
rn++
abstract class company {
  readonly name: string
  constructor(name2: string) {
  this.name = name2
  }
  abstract getst(): string[]
}
class mining extends company {
  getst(): string[] {
  return [matv[2][7]]
  }
}
let mys: company
mys = new mining(matv[1][7])
sheet.getRange("b" + rn).values = [[mys.getst() + " / " + mys.name]]
rn++
sheet.getRange("b" + rn).values = [["finished"]]
await context.sync();
});
}
    
/** Default helper for invoking an action and handling errors. */
async function tryCatch(callback) {
  try {
  await callback();
  } catch (error) {
  // Note: In a production add-in, you'd want to notify the user through your add-in's UI.
  console.error(error);
  }
}