Excel导入,注解工具类
本人不喜欢写文档,不喜欢看文档。直接代码。。。。这个比网上其他的工具类要好,采用注解方式,少了很多配置,比较适用于于前后端交互使用。。。。
package com.siwill.util;
import com.google.common.base.Strings;
import com.siwill.domain.enums.ExcelImport;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;
import java.io.InputStream;
import java.lang.reflect.Field;
import java.text.SimpleDateFormat;
import java.util.*;
/**
* Created by panweifu on 2019/4/12.
*/
public class MyExcelImportUtils<T> {
//保证线程安全的
private static final ThreadLocal<MyExcelImportUtils> UTILS_THREAD_LOCAL = new ThreadLocal<>();
public static final MyExcelImportUtils initialization() {
MyExcelImportUtils excelUtils = UTILS_THREAD_LOCAL.get();
if (excelUtils == null) {
excelUtils = new MyExcelImportUtils();
UTILS_THREAD_LOCAL.set(excelUtils);
}
return excelUtils;
}
public List<T> getExcelData(MultipartFile file, Class<T> clazz) throws Exception {
Field[] declaredFields = clazz.getDeclaredFiel