for (let c = 3; c < 15; c++) {
for(let i=0; i<row; i++){
let formula01 = `${Convert26(c+1)}${2+i*3} - ${Convert26(c+1)}${3+i*3}`
sheet.setFormula(
3+i*3,
c,
`=IFERROR(${formula01},"")`
);
let cellValue = sheet.getValue(3+i*3, c);
console.log('cellValue', cellValue) // 打印出来全是 null
}
} |