How to create a dropdown list and use it?


#1

I want to use Aspose.Excel components to create a simple dropdown list with two options: Y and N. And then use it to restrict the cells in one column. How can I do it? Thanks!


#2

I don’t clearly understand your need. Do you talk about AutoFilter feature in MS Excel? Please check http://www.aspose.com/wiki/default.aspx/Aspose.Excel/DataFilteringAndValidation.html for reference.