Free Support Forum - aspose.com

How to Add DropDown/Combo Box to excel using java

Hi : can i have reference for how to add dropdown to the excel using aspose java

@navneethr,

Thanks for your query.

You can implement DropDowns/ComboBox to worksheet cells, in two ways (please choose any of the approaches based on your specific needs):

  1. Add List data validation to cells, see the document (sub-topic) with example code for your reference:
    https://docs.aspose.com/display/cellsjava/Data+Filtering+and+Validation#DataFilteringandValidation-ProgrammingSample:ListDataValidation

  2. Add ComboBox forms controls to the worksheet. see the document for your reference:
    https://docs.aspose.com/display/cellsjava/Managing+Controls#ManagingControls-AddingComboBoxControltoaWorksheet

Hope, this helps a bit.