Hutool处理excel表头+数据

标题Hutool处理excel获取表头/数据并处理@TOC

返回对象实体

package org.springblade.modules.visual.vo;

import lombok.Data;

import java.io.Serializable;
import java.util.List;

@Data
public class ExcelStaticDataVO implements Serializable {

	private static final long serialVersionUID = 1L;

	//文件名
	private String fileName;

	//sheet数组
	private List<ExcelSheetDataVO> sheetDataVOList;
}

package org.springblade.modules.visual.vo;

import lombok.Data;

import java.io.Serializable;

@Data
public class ExcelSheetDataVO implements Serializable {

	private static final long serialVersionUID = 1L;

	//sheet名
	private String sheetName;

	//表信息
	private ExcelHeadDataVO dataVO;
}

package org.springblade.modules.visual.vo;

import lombok.Data;

import java.io.Serializable;
import java.util.List;

@Data
public class ExcelStaticDataVO implements Serializable {

	private static final long serialVersionUID = 1L;

	//文件名
	private String fileName;

	//sheet数组
	private List<ExcelSheetDataVO> sheetDataVOList;
}

数据处理

			ExcelReader reader = cn.hutool.poi.excel.ExcelUtil.getReader(file.getInputStream());
			//获取sheet
			Iterator<Sheet> iterator = ((HSSFWorkbook) reader.getWorkbook()).iterator();
			//创建sheet对象集合
			List<ExcelSheetDataVO> excelSheetDataVOS = new ArrayList<>();
			while (iterator.hasNext()) {
				ExcelSheetDataVO excelSheetDataVO = new ExcelSheetDataVO();
				String sheetName = iterator.next().getSheetName();
				excelSheetDataVO.setSheetName(sheetName);
				//获取表头数据
				Iterator<Cell> cellIterator = ((HSSFWorkbook) reader.getWorkbook()).getSheet(sheetName).getRow(0).cellIterator();
				ExcelHeadDataVO excelHeadDataVO = new ExcelHeadDataVO();
				List<String> headList = new ArrayList<>();
				while (cellIterator.hasNext()) {
					//添加表头
					headList.add(cellIterator.next().getStringCellValue());
				}
				excelHeadDataVO.setHeadList(headList);
				excelSheetDataVO.setDataVO(excelHeadDataVO);
				excelSheetDataVOS.add(excelSheetDataVO);
				//从第一行读取数据
				log.info("数据展示");
			}
			excelStaticDataVO.setFileName(file.getOriginalFilename());
			excelStaticDataVO.setSheetDataVOList(excelSheetDataVOS);