Independentsoft
- any library, any programming language
Home
Purchase
Support
Company
Contact
JSpreadsheet
>
Tutorial
> 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(); } } }
Need help? Ask our developers:
Name*
Email*
Message*