<dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>${poi.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>${poi.version}</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-scratchpad</artifactId>
            <version>${poi.version}</version>
        </dependency>

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springblade.busi.entity.PersonalInfo;
import org.springblade.busi.framework.annotation.InfoChangeAnnotation;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;
import java.io.InputStream;
import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class ExcelToObject1 {

	/**
	 * 讀取Excel文件，版本：只讀取基本信息一個Sheet，若有需要多個sheet在增加for循環(huán)
	 *
	 * @param file
	 * @return
	 */
	public List<PersonalInfo> toPersonalInfo(MultipartFile file) {

		//創(chuàng)建返回對象
		List<PersonalInfo> persons = new ArrayList<>();

		try (InputStream fis = file.getInputStream();
			 Workbook workbook = new XSSFWorkbook(fis)) {

			Class<?> clazz = PersonalInfo.class;

			//只讀取基本信息一個Sheet
			Sheet sheet = workbook.getSheetAt(0);
			Row headerRow = sheet.getRow(0);

			List<String> columnNames = new ArrayList<>();
			Iterator<Cell> cellIterator = headerRow.cellIterator();
			while (cellIterator.hasNext()) {
				Cell cell = cellIterator.next();
				columnNames.add(cell.getStringCellValue());
			}

			for (int rowIndex = 1; rowIndex <= sheet.getLastRowNum(); rowIndex++) {
				Row row = sheet.getRow(rowIndex);
				PersonalInfo person = (PersonalInfo) clazz.newInstance();

				//獲取Excel當(dāng)前行的第一位，若未null則不處理 ---> 防止poi讀取Excel多讀取沒有數(shù)據(jù)的一行，導(dǎo)致非空字段為空。
				Cell cellNow = row.getCell(0);
				if (cellNow == null) {
					break;
				}
				for (int columnIndex = 0; columnIndex < columnNames.size(); columnIndex++) {
					Cell cell = row.getCell(columnIndex);
					String columnName = columnNames.get(columnIndex);

					//通過實體類注解與Excel頭部中文進(jìn)行映射
					Field field = getFieldByColumnName(clazz, columnName);
					if (field != null) {
						field.setAccessible(true);
						field.set(person, getCellValueAsString(cell));
					}
				}
				//處理每一行Excel加到返回對象當(dāng)中
				persons.add(person);
			}

		} catch (IOException | IllegalAccessException | InstantiationException e) {
			e.printStackTrace();
			System.out.println(e.getMessage());
		}
		return persons;
	}

	//通過實體類注解與Excel頭部中文進(jìn)行映射
	private static Field getFieldByColumnName(Class<?> clazz, String columnName) {
		for (Field field : clazz.getDeclaredFields()) {
			InfoChangeAnnotation annotation = field.getAnnotation(InfoChangeAnnotation.class);
			if (annotation != null && annotation.value().equals(columnName)) {
				return field;
			}
		}
		return null;
	}

	//獲取每個單元格數(shù)據(jù)并轉(zhuǎn)為String，其他類型在上方做了ifelse
	private static String getCellValueAsString(Cell cell) {
		if (cell == null) {
			return null;
		}
		cell.setCellType(CellType.STRING);
		String cellValue = cell.getStringCellValue();
		System.out.println("getCellValueAsString:" + cellValue);
		return cellValue;
	}

@InfoChangeAnnotation("姓名")	
private String personalName;