你不需要过滤表，使用数组可以更有效地过滤。

function main(workbook: ExcelScript.Workbook) {
    // modify table name as needed
    let table1 = workbook.getTable("Table1");
    let dRange = table1.getColumn("Status").getRangeBetweenHeaderAndTotal();
    let dValue = dRange.getValues();
    let cRange = table1.getColumn("Difference").getRangeBetweenHeaderAndTotal();
    let cValue = cRange.getValues();
    const rowCount = cValue.length;
    for (let i = 0; i < rowCount; i++) {
        if (cValue[i][0] === 0) {
            dValue[i][0] = "Not Applicable"
        }
        else if (cValue[i][0] > 0) {
            dValue[i][0] = "No"
        }
        else {
            dValue[i][0] = "Yes"
        }
    }
    dRange.setValues(dValue);
}

字符串
使用conditional (ternary) operator简化

for (let i = 0; i < rowCount; i++) {
        dValue[i][0] = cValue[i][0] === 0 ? "Not Applicable" : (cValue[i][0] > 0 ? "No" : "Yes");
    }

型

第一个月