教你怎么将表格数据转化成Insert into语句

    cn.afterturn
    easypoi-spring-boot-starter
    4.2.0

 内容如下：

package cn.com.epicc.ecoop.jd.insured.service;

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;

public class ReaderTableToSqlUtils {

    public static void main(String[] args) throws Exception {
        writeStore("路径.xlsx");
    }

    private static void writeStore(String path) throws Exception {
        Workbook workbook = new XSSFWorkbook(new File(path));
        //读取excel中的sheet表名
        Sheet sheet = workbook.getSheet("sheet表名");
        int totalRow = sheet.getLastRowNum();
        System.out.println("总共：" + totalRow);
        //循环独处表中每一行中每一列的值
        for (int i = 1; i <= totalRow; i++) {
            Row row = sheet.getRow(i);
            String COMCODE = resultContent(row.getCell(1));
            String MAKECODE = resultContent(row.getCell(2));
            String AGENTCODE = resultContent(row.getCell(3));
            String HANDLERCODE = resultContent(row.getCell(4));
            String HANDLER1CODE = resultContent(row.getCell(5));
            String OPERATORCODE = resultContent(row.getCell(6));
            String APPROVERCODE = resultContent(row.getCell(7));
            String RATIonTYPE = "";
            String storeSql = "insert into 表名 (AREACODE,COMCODE,MAKECODE,AGENTCODE," +
                    "HANDLERCODE,HANDLER1CODE,OPERATORCODE,APPROVERCODE,RATIONTYPE,.......)"
                    + " values('" +"主键"+i + "','" + COMCODE + "','" + MAKECODE + "','" + AGENTCODE + "','"
                    + HANDLERCODE + "','"+HANDLER1CODE+"','"+OPERATORCODE+"','"+APPROVERCODE+"','"+RATIONTYPE+"');";
            System.out.println(storeSql);
            //将sql写入文档中
            writeTxtCount("存入sql文件.sql", storeSql);
        }
    }

    //传入文件路径  和生成的sql
    private static boolean writeTxtCount(String path, String content) {
        BufferedWriter bufferedWriter = null;
        try {
            bufferedWriter = new BufferedWriter(new FileWriter(path, true));
            bufferedWriter.write(content + "rn");
            return true;
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                bufferedWriter.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return false;
    }

    //转化成string
    private static String resultContent(Cell cell) {
        cell.setCellType(CellType.STRING);
        return cell.getStringCellValue();
    }
}

需要注意导包和版本之间的冲突，再就是表格第一行保留，否则将少读取一行数据