Excel Drop down list using Apache POI
apache-poi, excel, xssf
Solution
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.
Problem
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(); } } ```