Apache POI实现数据下拉框（HSSF和XSSF通用）

最新推荐文章于 2024-09-19 12:02:28 发布

Moncy Xu

最新推荐文章于 2024-09-19 12:02:28 发布

阅读量2.9k

点赞数

分类专栏： POI 文章标签： POI下拉框 POI数据下拉框

本文链接：https://blog.csdn.net/a823007573/article/details/102955634

版权

POI 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

文章目录

- 1.导入POI依赖
- 2.代码实现

1.导入POI依赖

<!-- HSSF .xls -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.1</version>
</dependency>
<!-- XSSF .xlsx -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.1</version>
</dependency>

2.代码实现

public void test(){
	// Workbook wb = new HSSFWorkbook();
	Workbook wb = new XSSFWorkbook();
    Sheet sheet = wb.createSheet("sheet0");
    // 设置区域范围， 参数：firstRow,lastRow,firstCol,lastCol
    // 示例为第一个单元格
    CellRangeAddressList cellRangeAddressList = new CellRangeAddressList(0, 0, 0, 0);
    DataValidationHelper dataValidationHelper = sheet.getDataValidationHelper();
    // 构造下拉框和数据
    DataValidationConstraint constraint = dataValidationHelper.createExplicitListConstraint(new String[]{"春", "夏", "秋", "冬"});
    // 绑定下拉框和区域
    DataValidation validation = dataValidationHelper.createValidation(constraint, cellRangeAddressList);
    // 为sheet添加验证
    sheet.addValidationData(validation);
    //wb.write(new FileOutputStream("D:\\test.xls"));
    wb.write(new FileOutputStream("D:\\test.xlsx"));
}