Data validation - dropdown list

The following example shows you how to create a dropdown list validation that restricts cell input to a predefined set of options.

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.DataValidation;
import com.independentsoft.office.spreadsheet.DataValidationType;
import com.independentsoft.office.spreadsheet.DataValidations;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Worksheet sheet = new Worksheet();

            sheet.set("A1", new Cell("Status"));
            sheet.set("B1", new Cell("Priority"));

            DataValidation statusValidation = new DataValidation();
            statusValidation.setType(DataValidationType.LIST);
            statusValidation.setFormula1("\"Open,In Progress,Closed\"");
            statusValidation.setReferenceSequence("A2:A100");
            statusValidation.setShowErrorMessage(true);
            statusValidation.setErrorTitle("Invalid Status");
            statusValidation.setErrorMessage("Please select a valid status from the list.");

            DataValidation priorityValidation = new DataValidation();
            priorityValidation.setType(DataValidationType.LIST);
            priorityValidation.setFormula1("\"Low,Medium,High,Critical\"");
            priorityValidation.setReferenceSequence("B2:B100");
            priorityValidation.setShowErrorMessage(true);
            priorityValidation.setErrorTitle("Invalid Priority");
            priorityValidation.setErrorMessage("Please select Low, Medium, High or Critical.");

            DataValidations validations = new DataValidations();
            validations.getItems().add(statusValidation);
            validations.getItems().add(priorityValidation);

            sheet.setDataValidations(validations);

            Workbook book = new Workbook();
            book.getSheets().add(sheet);
            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Data validation - dropdown list

Need help? Ask our developers: