Excel Drop down list using Apache POI

Question

I need to create a drop down list in excel file using Apache POI. and I am able to do that so But I am not able to make first item in drop down list as default Item.

public class sd {

/**
 * @param args
 * @throws IOException 
 */
public static void main(String[] args) throws IOException {

DataValidation dataValidation = null;
DataValidationConstraint constraint = null;
DataValidationHelper validationHelper = null;

 XSSFWorkbook wb = new XSSFWorkbook();
 XSSFSheet sheet1=(XSSFSheet) wb.createSheet("sheet1");


    validationHelper=new XSSFDataValidationHelper(sheet1);
    CellRangeAddressList addressList = new  CellRangeAddressList(0,5,0,0);
    constraint =validationHelper.createExplicitListConstraint(new String[]{"SELECT","10", "20", "30"});
    dataValidation = validationHelper.createValidation(constraint, addressList);
    dataValidation.setSuppressDropDownArrow(true);      
    sheet1.addValidationData(dataValidation);

    FileOutputStream fileOut = new FileOutputStream("c:\\temp\\vineet.xlsx");
    wb.write(fileOut);
    fileOut.close();
}

}

@Lucifer I am facing issue while creating large list drop-down. Is there a solution for increasing list size? — Aakash Patel, Feb 11 '21 at 05:06

score 7 · Answer 1 · answered Jul 16 '12 at 05:47

7

to set a default value, just setCellValue("first_item_value");

sheet.getRow(1).getCell(index).setCellValue("my_default_value");

I have did it as facing the same problem.

answered Jul 16 '12 at 05:47

meadlai

895
1
9
22

1

But this does not comes as one of the option in the dropdownlist. What if we need it in the list? Say "SELECT" should comes as default in the list. – zeewagon Apr 19 '17 at 13:27

score 1 · Answer 2 · edited Jun 19 '18 at 16:15

1

Here is my code:

Cell cell = row.createCell(2);
cell.setCellValue("SELECT");

//2 is the 2nd cell in my case

edited Jun 19 '18 at 16:15

Michael

3,093
7
39
83

answered Jun 19 '18 at 14:23

user9962613

11
1

Excel Drop down list using Apache POI

2 Answers2

Linked