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();
		}
	}

}