修复

xieb

2025-01-21 bd8d88e5e984e59a5c895ec1a254e3dbae1f9f21

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
package org.springblade.modules.assessment.utils;
 
import com.alibaba.excel.read.builder.ExcelReaderBuilder;
import org.springblade.core.excel.listener.ImportListener;
import org.springblade.core.excel.support.ExcelImporter;
import org.springblade.core.excel.util.ExcelUtil;
import org.springframework.web.multipart.MultipartFile;
 
/**
 * @PROJECT_NAME: zttj-java-boot
 * @DESCRIPTION:
 * @USER: aix
 * @DATE: 2024/2/20 16:19
 */
public class AssExcelUtil extends ExcelUtil {
 
    /**
     * 自定义模板导入保存
     * @param excel 文件
     * @param importer
     * @param clazz
     * @param sheetNo sheet序号(从0开始)
     * @param headRowNumber 表头行数
     * @param <T>
     */
    public static <T> void save(MultipartFile excel, ExcelImporter<T> importer, Class<T> clazz,int sheetNo, int headRowNumber) {
        ImportListener<T> importListener = new ImportListener<>(importer);
        ExcelReaderBuilder builder = getReaderBuilder(excel, importListener, clazz);
        if (builder != null) {
            builder.sheet(sheetNo).headRowNumber(headRowNumber).doRead();
        }
    }
 
}