ExcelScript.CellControl type

包:
ExcelScript

表示单元格内的可交互控件。

type CellControl =
        | UnknownCellControl
        | EmptyCellControl
        | MixedCellControl
        | CheckboxCellControl;

注解

使用方

通过以下链接详细了解此类型别名中的类型。

ExcelScript.UnknownCellControl、 ExcelScript.EmptyCellControl、 ExcelScript.MixedCellControl、 ExcelScript.CheckboxCellControl

示例

/**
 * This script creates a task list and displays the completion values as checkboxes.
 */
function main(workbook: ExcelScript.Workbook) {
  const sheet = workbook.addWorksheet();
  const taskRange = sheet.getRange("A1:B4");

  // Add tasks and their completion values.
  taskRange.setValues([
    ["Task", "Complete"],
    ["Review data", true],
    ["Update chart", false],
    ["Send report", false]
  ]);

  // Display the Boolean values in the Complete column as checkboxes.
  const checkboxRange = sheet.getRange("B2:B4");
  const checkboxControl: ExcelScript.CellControl = {
    type: ExcelScript.CellControlType.checkbox
  };
  checkboxRange.setControl(checkboxControl);

  taskRange.getFormat().autofitColumns();
}