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