feat: Excel导入实体接口

gongchunyi

3 天以前 328ba0ab2e306f4c67baeee99715090024112cd5

 src/main/java/com/ruoyi/common/utils/poi/ExcelUtil.java

@@ -23,7 +23,7 @@
import java.util.Set;

import java.util.UUID;

import java.util.stream.Collectors;

import javax.servlet.http.HttpServletResponse;

import jakarta.servlet.http.HttpServletResponse;

import org.apache.commons.lang3.ArrayUtils;

import org.apache.commons.lang3.RegExUtils;

import org.apache.commons.lang3.reflect.FieldUtils;

@@ -476,6 +476,22 @@
                            val = DateUtil.getJavaDate((Double) val);

                        }

                    }

                    else if (LocalDate.class == fieldType)

                    {

                        if (val instanceof String)

                        {

                            Date date = DateUtils.parseDate(val);

                            val = StringUtils.isNull(date) ? null : DateUtils.toLocalDate(date);

                        }

                        else if (val instanceof Date)

                        {

                            val = DateUtils.toLocalDate((Date) val);

                        }

                        else if (val instanceof Double)

                        {

                            val = DateUtils.toLocalDate(DateUtil.getJavaDate((Double) val));

                        }

                    }

                    else if (Boolean.TYPE == fieldType || Boolean.class == fieldType)

                    {

                        val = Convert.toBool(val, false);

@@ -518,6 +534,9 @@
                        }

                        ReflectUtils.invokeSetter(entity, propertyName, val);

                    }

                }

                if (entity instanceof ExcelRowAware) {

                    ((ExcelRowAware) entity).setExcelRowNum(i + 1);

                }

                list.add(entity);

            }

@@ -657,6 +676,15 @@
                        } else if (val instanceof Double) {

                            val = DateUtil.getJavaDate((Double) val);

                        }

                    } else if (LocalDate.class == fieldType) {

                        if (val instanceof String) {

                            Date date = DateUtils.parseDate(val);

                            val = StringUtils.isNull(date) ? null : DateUtils.toLocalDate(date);

                        } else if (val instanceof Date) {

                            val = DateUtils.toLocalDate((Date) val);

                        } else if (val instanceof Double) {

                            val = DateUtils.toLocalDate(DateUtil.getJavaDate((Double) val));

                        }

                    } else if (Boolean.TYPE == fieldType || Boolean.class == fieldType) {

                        val = Convert.toBool(val, false);

                    }

@@ -689,6 +717,9 @@
                        ReflectUtils.invokeSetter(entity, propertyName, val);

                    }

                }

                if (entity instanceof ExcelRowAware) {

                    ((ExcelRowAware) entity).setExcelRowNum(i + 1);

                }

                list.add(entity);

            }

        }