问确定是否将条件格式应用于Office-js中的单元格或单元格区域

EN

worksheetRange.conditionalFormats.getItemAt(0).getRange();

    const sheet = context.workbook.worksheets.getItem("Sample");
    const worksheetRange = sheet.getRange();
    worksheetRange.conditionalFormats.load("type");
    await context.sync();

    let cfRangePairs: { cf: Excel.ConditionalFormat; range: Excel.Range }[] = [];
    worksheetRange.conditionalFormats.items.forEach((item) => {
      cfRangePairs.push({
        cf: item,
        range: item.getRange().load("address")
      });
    });

    await context.sync();

    if (cfRangePairs.length > 0) {
      cfRangePairs.forEach((item) => {
        console.log(item.cf.type);
        console.log(item.range.address);

      });
    } else {
      console.log("No conditional formats applied.");
    }
  });