This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can trysigning in orchanging directories.
Access to this page requires authorization. You can trychanging directories.
Represents a checkbox. This is a cell control that allows a user to toggle the boolean value in a cell.
// 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();});| type |
Was this page helpful?
Was this page helpful?