| | |
| | | package com.vincent.rsf.server.common.utils; |
| | | |
| | | import cn.afterturn.easypoi.excel.entity.ImportParams; |
| | | import com.vincent.rsf.framework.common.Cools; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import org.apache.poi.hssf.usermodel.HSSFWorkbook; |
| | | import org.apache.poi.ss.usermodel.Row; |
| | | import org.apache.poi.ss.usermodel.Sheet; |
| | | import org.apache.poi.ss.usermodel.Workbook; |
| | | import org.apache.poi.poifs.filesystem.POIFSFileSystem; |
| | | import org.apache.poi.ss.usermodel.*; |
| | | import org.apache.poi.xssf.usermodel.XSSFWorkbook; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.io.IOException; |
| | |
| | | import java.lang.reflect.Modifier; |
| | | import java.net.URLEncoder; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.*; |
| | | |
| | | /** |
| | | * Created by vincent on 2/17/2024 |
| | |
| | | continue; |
| | | } |
| | | |
| | | field.setAccessible(true); // 此行很重要,特别是字段为private时 |
| | | // 此行很重要,特别是字段为private时 |
| | | field.setAccessible(true); |
| | | Object value = null; |
| | | try { |
| | | value = field.get(t); |
| | |
| | | return workbook; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 添加导入excel配置参数 |
| | | * 注:默认配置可满足当前需求 |
| | | * @return |
| | | */ |
| | | public static ImportParams getDefaultImportParams() { |
| | | ImportParams params = new ImportParams(); |
| | | return params; |
| | | } |
| | | |
| | | } |