Reputation: 1
I would like to use the office JS API to perform data validations on cells in excel, more specifically allowing a user to select data from a drop-down only. if anyone can provide me with a link to code samples that would be a great help. I know this feature is in Beta, but want to use it for a test environment.
thanks.
Upvotes: 0
Views: 60
Reputation: 9684
Yes. There is a code snippet that does this. You can see it in the Script Lab tool from AppSource. In the tree of Samples, scroll down to the Preview section. Open the snippet called Data Validation.
Upvotes: 1