Apache POI将txt文件读取为excel文件

<dependencies>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>5.2.3</version>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>5.2.3</version>
    </dependency>
</dependencies>

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

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.FileOutputStream;
import java.io.IOException;

public class TxtToExcelConverter {

    public static void main(String[] args) {
        String txtFilePath = "path/to/your/input.txt";
        String excelFilePath = "path/to/your/output.xlsx";

        try (BufferedReader br = new BufferedReader(new FileReader(txtFilePath));
             Workbook workbook = new XSSFWorkbook();
             FileOutputStream fileOut = new FileOutputStream(excelFilePath)) {

            Sheet sheet = workbook.createSheet("Text Data");
            String line;
            int rowNum = 0;

            while ((line = br.readLine()) != null) {
                Row row = sheet.createRow(rowNum++);
                String[] data = line.split("\\s+"); // 根据空格分隔数据
                int colNum = 0;

                for (String field : data) {
                    Cell cell = row.createCell(colNum++);
                    cell.setCellValue(field);
                }
            }

            workbook.write(fileOut);
            System.out.println("Excel file has been created successfully.");

        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}