解决JAVA一个接口同时接收【文件】和【json】2种参数,并完成业务实现

maven依赖

   org.apache.poi
    poi
    4.1.2


    org.apache.poi
    poi-ooxml
    4.1.2

ExcelUtils工具类,解析表格数据,不解析表头行

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFRichTextString;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;


public class ExcelUtils {

    public static List> getListByExcel(InputStream in, String fileName) throws Exception {
        List> list = new ArrayList<>();

        // 创建excel工作簿
        Workbook work = getWorkbook(in, fileName);
        if (null == work) {
            throw new Exception("创建Excel工作薄为空！");
        }
        Sheet sheet = null;
        Row row = null;
        Cell cell = null;

        sheet = work.getSheetAt(0);
        // 滤过第一行标题
        for (int j = sheet.getFirstRowNum(); j <= sheet.getLastRowNum(); j++) {
            row = sheet.getRow(j);
            if (row == null || row.getFirstCellNum() == j) {
                continue;
            }
            List