easyexcel 添加下拉框

绝地灬酷狼 2023-03-01 13:28 139阅读 0赞

--------------------

### easyexcel 添加下拉框 ###

### \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* ###

**相关类与接口**

**Sheet（部分方法）**

public interface Sheet extends Iterable<Row> {
    
        DataValidationHelper getDataValidationHelper();
        void addValidationData(DataValidation var1);
    }

**DataValidationHelper**

public interface DataValidationHelper {
    
        DataValidationConstraint createCustomConstraint(String var1);
        DataValidationConstraint createFormulaListConstraint(String var1);
        DataValidationConstraint createExplicitListConstraint(String[] var1);
    
    
        DataValidationConstraint createDecimalConstraint(int var1, String var2, String var3);
        DataValidationConstraint createIntegerConstraint(int var1, String var2, String var3);
        DataValidationConstraint createNumericConstraint(int var1, int var2, String var3, String var4);
        DataValidationConstraint createTextLengthConstraint(int var1, String var2, String var3);
    
        DataValidationConstraint createDateConstraint(int var1, String var2, String var3, String var4);
        DataValidationConstraint createTimeConstraint(int var1, String var2, String var3);
    
    
        DataValidation createValidation(DataValidationConstraint var1, CellRangeAddressList var2);
    }

**CellRangeAddressList**

public class CellRangeAddressList {
        protected final List<CellRangeAddress> _list;
    
        public CellRangeAddressList() {
        public CellRangeAddressList(int firstRow, int lastRow, int firstCol, int lastCol) {
        public CellRangeAddressList(RecordInputStream in) {
    
    
        public void addCellRangeAddress(int firstRow, int firstCol, int lastRow, int lastCol) {
        public void addCellRangeAddress(CellRangeAddress cra) {
    
    
        public CellRangeAddress remove(int rangeIndex) {
        public CellRangeAddress getCellRangeAddress(int index) {
        public CellRangeAddress[] getCellRangeAddresses() {
    
        public int getSize() {
        public int countRanges() {
        public static int getEncodedSize(int numberOfRanges) {
    
    
        public int serialize(int offset, byte[] data) {
        public void serialize(LittleEndianOutput out) {
    
        public CellRangeAddressList copy() {

**CellRangeAddress**

public class CellRangeAddress extends CellRangeAddressBase {
        public static final int ENCODED_SIZE = 8;
    
        public CellRangeAddress(int firstRow, int lastRow, int firstCol, int lastCol) {
        public CellRangeAddress(RecordInputStream in) {
    
    
        public CellRangeAddress copy() {
        public static CellRangeAddress valueOf(String ref) {
    
        public String formatAsString() {
        public String formatAsString(String sheetName, boolean useAbsoluteAddress) {
    
        public void serialize(LittleEndianOutput out) {
        public static int getEncodedSize(int numberOfItems) {
    
        private static int readUShortAndCheck(RecordInputStream in) {

**AbstractSheetWriteHandler**

public abstract class AbstractSheetWriteHandler implements SheetWriteHandler {
    
        @Override
        public void beforeSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
    
        }
    
        @Override
        public void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
    
        }
    }

**SheetWriteHandler**

public interface SheetWriteHandler extends WriteHandler {
    
        void beforeSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder);
    
        void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder);
    }

**WriteHandler**

public interface WriteHandler extends Handler {
    }

**Handler**

public interface Handler {
    }

### \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* ###

**示例**

**Test**

@Data
    class Person{
    
        private Integer id;
        private String name;
        private Integer age;
        private String sex;
    }
    
    class CustomSheetWriteHandler extends AbstractSheetWriteHandler{
    
        @Override
        public void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
            CellRangeAddressList list=new CellRangeAddressList(1,20,2,3); //1到20行、2到3列添加下拉框
    
            DataValidationHelper helper=writeSheetHolder.getSheet().getDataValidationHelper();
            DataValidationConstraint constraint=helper.createExplicitListConstraint(new String[]{"男","女"});
            DataValidation dataValidation=helper.createValidation(constraint,list);
    
            writeSheetHolder.getSheet().addValidationData(dataValidation);
        }
    }
    
    public class Test {
    
        private static final String write_path="e:"+ File.separator+"java"+File.separator+"easyexcel"+File.separator+"write4.xlsx";
    
        public static void write(){
            EasyExcel.write(write_path,Person.class).registerWriteHandler(new CustomSheetWriteHandler())
                    .sheet().doWrite(data());
        }
    
        private static List<Person> data(){
            List<Person> list=new ArrayList<>();
    
            for (int i=0;i<5;i++){
                Person person=new Person();
                person.setId(i);
                person.setName("瓜田李下 "+i);
                person.setAge(20+i);
    
                list.add(person);
            }
    
            return list;
        }
    
        public static void main(String[] args){
            write();
        }
    }

**\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**使用测试**

![20200727161622346.png][]

**sex列添加下拉框成功，内容为：男、女**

[20200727161622346.png]: /images/20230208/b8a6c32ee72545d7a6f72470e4a177aa.png