Data Validation

The following example shows you how to create data validation.

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
        {
            Workbook book = new Workbook();
            Worksheet sheet1 = new Worksheet();

            DataValidation validation1 = new DataValidation();

            validation1.setType(DataValidationType.WHOLE_NUMBER);
            validation1.setPromptTitle("Validation title");
            validation1.setPrompt("You have to enter integer between 1 and 999.");
            validation1.setErrorTitle("Error");
            validation1.setErrorMessage("Wrong value");
            validation1.setReferenceSequence("A1:A1048576"); //A column
            validation1.setShowErrorMessage(true);
            validation1.setShowInputMessage(true);
            validation1.setFormula1("1"); //Min value
            validation1.setFormula2("999"); //Max value
            
            DataValidations dataValidations = new DataValidations();
            dataValidations.getItems().add(validation1);
            
            sheet1.setDataValidations(dataValidations);
                       
            book.getSheets().add(sheet1);

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

Independentsoft - any library, any programming language

JSpreadsheet > Tutorial > Data Validation

Need help? Ask our developers: