org.dromara.hutool.poi.excel.writer

Class DataValidationUtil

java.lang.Object

org.dromara.hutool.poi.excel.writer.DataValidationUtil

public class DataValidationUtil
extends Object

Excel数据验证相关工具

Since:

6.0.0

Author:

Looly

Constructor Summary

Constructors

Constructor and Description
DataValidationUtil()

Method Summary

Modifier and Type	Method and Description
static void	addSelect(org.apache.poi.ss.usermodel.Sheet sheet, org.apache.poi.ss.util.CellRangeAddressList regions, String... selectList) 增加下拉列表

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DataValidationUtil

public DataValidationUtil()

Method Detail

addSelect

public static void addSelect(org.apache.poi.ss.usermodel.Sheet sheet,
                             org.apache.poi.ss.util.CellRangeAddressList regions,
                             String... selectList)

增加下拉列表

Parameters:

sheet - Sheet

regions - CellRangeAddressList 指定下拉列表所占的单元格范围

selectList - 下拉列表内容

Since:

4.6.2