Hello all,

I am using poi3.7 to create a dropdown-list column, to let user select the
value.
but how to set a default value in every cell in advance?
Use setCellValue("defaultValue"). it doesn't work at all.
Could anyone give me a hand? or someone face the thing problem?
--code--
Row ddlrow = sheet.getRow(1);
*if*(ddlrow == *null*)}
sheet.createRow(1).createCell(index);
sheet.getRow(1).getCell(index).setCellValue("MY_DEFAULT_VALUE");
}

--code--
//create data referenc
 HSSFName namedRange = workbook.createName();
          namedRange.setNameName(dicName);
          namedRange.setRefersToFormula(region);
          //create drop-down region
          CellRangeAddressList addressList = *new* CellRangeAddressList(1,
EXPORT_BLANK_LINES, index,            index);
         DVConstraint dvConstraint = DVConstraint.*
createFormulaListConstraint*(dicName);
         DataValidation dataValidation =
*new*HSSFDataValidation(addressList, dvConstraint);
         dataValidation.setSuppressDropDownArrow(*false*);
         sheet.addValidationData(dataValidation);

Regards,
Mead

Reply via email to