Aspose 设置单元格下拉选择框（Java代码实现）

     // Create Workbook object
    Workbook workbook = new Workbook();

    // Create Worksheet object
    Worksheet worksheet = workbook.getWorksheets().get(0);

    // Create data source for drop down list
    String[] items = {"Item 1", "Item 2", "Item 3", "Item 4"};

    // Create CellArea object for data source of drop down list
    CellArea area = new CellArea();
    area.StartRow = 0;
    area.EndRow = 0;
    area.StartColumn = 0;
    area.EndColumn = 0;

    // Add DataValidation object with multi-select drop down list
    int validations = worksheet.getValidations().add(area);
    Validation validation = worksheet.getValidations().get(validations);
    validation.setType(ValidationType.LIST);
    validation.setFormula1(String.join(",", items));
    validation.setShowError(true);
    validation.setInCellDropDown(true);
    validation.setShowInput(true);
    validation.setInputMessage("Please select one or more items from the list.");

    // Save Workbook
    workbook.save("D:\\javaenv/output.xlsx");