It would be great if we could have check boxes as a feature for Excel Online. Google Sheets has this feature but Excel Online doesn't please add it.
4 Comments
- AdrianWu
Microsoft
Hi! I'm excited to share some great news - the Checkbox is not only supported in Excel Online, but its API is also supported in the latest Excel Requirement Set 1.18!
You can now add and manage the in-cell checkbox with the following APIs:- Excel.Range.Control
- Excel.Range.ClearOrResetContents()
- Excel.RangeAreas.ClearOrResetContents()
Please check out the details here:
Excel Range Control
Excel JS API 1.18
Below is a sample code snippet that demonstrates how you can set a checkbox in cells:async function run() { await Excel.run(async (context) => { let range = context.workbook.getSelectedRange(); range.control = { type: "Checkbox" }; await context.sync(); }); }Hope this is helpful!!
- lindalu-MSFT
Microsoft
Status changed:NewtoCompleted - lindalu-MSFT
Microsoft
PedroNL , we apologize for the confusion where to post your Excel product feedback. This community was intended to be a temporary location for add-ins developers to submit feature suggestions between Microsoft moving off of UserVoice and the release of Microsoft's official Feedback portal app. Now that the latter is released, we encourage you to resubmit your feature suggestion on the official Excel Feedback portal at Excel · Community (microsoft.com).
Kind regards,
Linda
Microsoft 365 Developer Platform community steward
- PedroNLBrass Contributor
Bump