Excel.CellControl type

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

Remarks

API set: ExcelApi 1.18

Used by

• Excel.Range: control

Learn more about the types in this type alias through the following links.

Excel.UnknownCellControl, Excel.EmptyCellControl, Excel.MixedCellControl, Excel.CheckboxCellControl

Examples

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/42-range/range-cell-control.yaml

// Add checkboxes to the table.
await Excel.run(async (context) => {
 const sheet = context.workbook.worksheets.getActiveWorksheet();

 // Get the second column in the table, without the header.
 const range = sheet.tables.getItem("FruitTable").columns.getItem("Analysis").getDataBodyRange();

 // Change the boolean values to checkboxes.
 range.control = {
 type: Excel.CellControlType.checkbox
 };
 await context.sync();
});