使用Apache POI导入CSV数据

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

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.util.ArrayList;
import java.util.List;

public class CSVToExcelConverter {
    public static void main(String[] args) throws IOException {
        String csvFilePath = "path/to/csv/file.csv";
        String outputFilePath = "path/to/output/excel/file.xlsx";

        List<String[]> csvData = readCSV(csvFilePath);
        writeToExcel(csvData, outputFilePath);
    }

    private static List<String[]> readCSV(String csvFilePath) throws IOException {
        List<String[]> data = new ArrayList<>();
        Files.lines(Paths.get(csvFilePath)).forEach(line -> {
            String[] values = line.split(",");
            data.add(values);
        });
        return data;
    }

    private static void writeToExcel(List<String[]> csvData, String outputFilePath) throws IOException {
        try (Workbook workbook = new XSSFWorkbook()) {
            Sheet sheet = workbook.createSheet("Sheet1");

            for (int rowNum = 0; rowNum < csvData.size(); rowNum++) {
                String[] rowData = csvData.get(rowNum);
                Row row = sheet.createRow(rowNum);

                for (int colNum = 0; colNum < rowData.length; colNum++) {
                    Cell cell = row.createCell(colNum);
                    cell.setCellValue(rowData[colNum]);
                }
            }

            try (FileOutputStream outputStream = new FileOutputStream(new File(outputFilePath))) {
                workbook.write(outputStream);
            }
        }
    }
}