spring boot读取Excel操作示例

spring boot读取读取Excel操作示例操作示例

主要介绍了spring boot读取Excel操作,结合实例形式详细分析了spring boot解析、读取Excel相关操作技巧,需要

的朋友可以参考下

本文实例讲述了spring boot读取Excel操作。分享给大家供大家参考，具体如下：

首先引入相关依赖

<!--解析office相关文件-->

<dependency>

<groupId>org.apache.poi</groupId>

<version>3.17</version>

</dependency>

<!--解析office相关文件-->

工具类

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.Cell;

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.xssf.usermodel.XSSFWorkbook;

import java.util.HashMap;

import java.util.Map;

public class OfficeUtils {

protected static final Logger logger = LoggerFactory.getLogger(OfficeUtils.class);

public static Map<Integer, Map<Integer, Object>> readExcelContentz(MultipartFile file) throws Exception {

Map<Integer, Map<Integer, Object>> content = new HashMap<Integer, Map<Integer, Object>>();

// 上传文件名

Workbook wb = getWb(file);

if (wb == null) {

throw new BusinessException(ErrorType.WORK_BOOK_EMPTY);

// 正文内容应该从第二行开始,第一行为表头的标题

for (int i = 1; i <= rowNum; i++) {

row = sheet.getRow(i);

int j = 0;

Map<Integer, Object> cellValue = new HashMap<Integer, Object>();

while (j < colNum) {

Object obj = getCellFormatValue(row.getCell(j));

cellValue.put(j, obj);

j++;

}

Object cellvalue = "";

if (cell != null) {

switch (cell.getCellTypeEnum()) {

case NUMERIC:

cellvalue = String.valueOf(cell.getNumericCellValue());

break;

case FORMULA: {

cellvalue = cell.getDateCellValue();

break;