Excel使用Apache POI下拉列表-Java 学习之路

我需要使用Apache POI在excel文件中创建一个下拉列表 . 我能够做到这一点但是我无法将下拉列表中的第一项作为默认项目 .

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();
}

}

2 回答

7
设置默认值，只需setCellValue（“first_item_value”）;
```
sheet.getRow(1).getCell(index).setCellValue("my_default_value");
```
面对同样的问题，我已经做到了 .
回复于 2024-04-26T03:15:00+08:00

这是我的代码：

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

//2 is the 2nd cell in my case

回复于 2024-04-26T03:15:00+08:00

Excel使用Apache POI下拉列表

2 回答

相关问题