java实现下载excel读取与生成超详细

背景：没啥背景，就是要做这个功能

创建ExcelUtil工具类，具体导入导出方法如下

/**
 * excel导入
 * @param inputStream 导入的excel文件
 * @return
 */
public static List<Invt> excelToShopIdList(InputStream inputStream) {
    List<Invt> list = new ArrayList<>();
    Workbook workbook = null;
    try {
        workbook = WorkbookFactory.create(inputStream);
        inputStream.close();
        //工作表对象
        Sheet sheet = workbook.getSheetAt(0);
        //总行数
        int rowLength = sheet.getLastRowNum();
        //            System.out.println("总行数有多少行" + rowLength);
        //工作表的列
        Row row = sheet.getRow(0);
        //总列数
        int colLength = row.getLastCellNum();
        //            System.out.println("总列数有多少列" + colLength);
        //得到指定的单元格
        Cell cell = row.getCell(0);
        for (int i = 0; i <= rowLength; i++) {
            Invt jiFenExcel = new Invt();
            row = sheet.getRow(i);
            //循环获取每列excel内容
            for (int j = 0; j < colLength; j++) {
                //列：                    cell = row.getCell(j);
                //                    System.out.print(cell + ",");
                if (cell != null) {
                    cell.setCellType(Cell.CELL_TYPE_STRING);
                    String data = cell.getStringCellValue();
                    data = data.trim();
                    //                        System.out.print(data);
                    //                        if (StringUtils.isNumeric(data)) {
                    if (j == 0) {
                        jiFenExcel.settId(data);
                    } else if (j == 1) {
                        jiFenExcel.setNumber(Integer.parseInt(data));
                    }