导入——springboot+poi实现导入功能
1.需求
把上述的excel表中的输入 导入到数据库中
2.编写导入工具类 ImportUtils
import com.safesoft.domain.eval.enterprise.EnterpriseService;
import com.safesoft.domain.eval.enterprise.entity.ImportEnterprise;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;
import java.io.IOException;
import java.io.InputStream;
/**
* 导入工具类
* @Author: CTW
* @Date: create in 2021/7/24
*/
public class ImportUtils {
public static void ImportBootUser(MultipartFile file, EnterpriseService enterpriseService) {
XSSFWorkbook workBook = null;
try (InputStream inputStream = file.getInputStream()) {
//读取文件流
workBook = new XSSFWorkbook(inputStream);
//读取工作表
XSSFSheet sheet = workBook.getSheetAt(0);
for (int i = 2; i <= sheet.getLastRowNum