How to display two independent different drop down list in Excel using Apache POI API? Able to display basicArray in excel in 11th column, but how to display 2nd array (advancedArray) in 12th column of xls? Is it possible to display two independent drop downs in excel columns? I see many examples for implementing the drop down list using the hidden sheet. But not displaying two independent drop down list. Please provide the sample code.
String[] basicArray= null;
String[] advancedArray= null;
if(BasicList!=null && BasicList.size() >0){
basicArray= new String[BasicList.size()];
for(int i =0; i<BasicList.size(); i++){
KeyValueSDO data =BasicList.get(i);
if(data!=null){
basicArray[i]=data.getKey();
}
}
}
if(AdvancedIdsList!=null && AdvancedIdsList.size() >0){
advancedArray= new String[AdvancedIdsList.size()];
for(int i =0; i<AdvancedIdsList.size(); i++){
KeyValueSDO data =AdvancedIdsList.get(i);
if(data!=null){
advancedArray[i]=data.getKey();
}
}
}
XSSFSheet spreadsheet = workbook.createSheet("Test Template Data");
XSSFDataValidationHelper dvHelper = new XSSFDataValidationHelper(spreadsheet);
//Adjustment Value Validation
CellRangeAddressList addressList = new CellRangeAddressList(1, 9999, 11, 11);
XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint)
//Defining the AdjustmentValue List dropdown display
dvHelper.createExplicitListConstraint(basicArray);
XSSFDataValidation dataValidation = (XSSFDataValidation)dvHelper.createValidation(dvConstraint, addressList);
dataValidation.setSuppressDropDownArrow(true);
dataValidation.setErrorStyle(dataValidation.getErrorStyle());
dataValidation.createErrorBox("Error", "Select the entry from List only");
dataValidation.setShowErrorBox(true);
spreadsheet.addValidationData(dataValidation);