How to display two independent different drop down list different list in Excel using Apache POI API

0 votes

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);
Apr 4, 2024 in Java by anonymous

edited Mar 5 6 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP