Excel导出转文本

package com.atguigu.blog.web;

import cn.afterturn.easypoi.excel.ExcelImportUtil;
import cn.afterturn.easypoi.excel.entity.ImportParams;
import cn.afterturn.easypoi.excel.entity.result.ExcelImportResult;
import com.atguigu.blog.pojo.Demo;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import java.io.*;
import java.util.List;

@RestController
@RequestMapping("")
public class ExcelController {

    @PostMapping(value = "/excel")
    @ResponseBody
    public void excel(@RequestParam("file") MultipartFile file) {
        List<Demo> list = null;
        ExcelImportResult<Demo> result = null;

        try {
            ImportParams importParams = new ImportParams();
            importParams.setTitleRows(1);
            importParams.setHeadRows(1);
            result = ExcelImportUtil.importExcelMore(file.getInputStream(), Demo.class, importParams);
            list = result.getList();
            StringBuilder stringBuilder = new StringBuilder();
            list.forEach(demo -> {
                // 根据业务需求改
                System.out.println(demo);
                String email = demo.getEmail();
                String id = demo.getId();
                String str = "UPDATE auth_user SET USER_EMAIL = '"+email+"' WHERE USER_ID = '"+id+"';";
                stringBuilder.append(str).append("\n");
            });
            File file1 = new File("C:\\Users\\baidu\\Desktop" + File.separator + "excelSql.sql");
            if(!file1.getParentFile().exists()){
                file1.getParentFile().mkdirs();
            }

            Writer out = null;
            out = new FileWriter(file1);
            out.write(stringBuilder.toString());
            out.close();
        } catch (Exception e) {
            e.printStackTrace();
        }

    }
}

DevToCoding ｜ Java面试指南、学习笔记