Java后台如何高效地将XLSX文件转换为CSV文件？

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

import java.io.*;
import java.util.Iterator;

public class XlsxToCsvConverter {

    public static void convertXlsxToCsv(String xlsxFilePath, String csvFilePath) throws IOException {
        Workbook workbook = WorkbookFactory.create(new File(xlsxFilePath));
        Sheet sheet = workbook.getSheetAt(0); // 获取第一个sheet

        FileWriter writer = new FileWriter(csvFilePath);

        Iterator<Row> rowIterator = sheet.iterator();
        while (rowIterator.hasNext()) {
            Row row = rowIterator.next();
            Iterator<Cell> cellIterator = row.iterator();
            while (cellIterator.hasNext()) {
                Cell cell = cellIterator.next();
                String cellValue = getCellValue(cell);
                writer.append(cellValue);
                if (cellIterator.hasNext()) {
                    writer.append(",");
                }
            }
            writer.append("\n");
        }

        writer.flush();
        writer.close();
        workbook.close();
    }


    private static String getCellValue(Cell cell) {
        switch (cell.getCellType()) {
            case STRING:
                return cell.getStringCellValue();
            case NUMERIC:
                return String.valueOf(cell.getNumericCellValue());
            case BOOLEAN:
                return String.valueOf(cell.getBooleanCellValue());
            case FORMULA:
                return cell.getCellFormula(); //  处理公式，根据实际情况选择合适的处理方式
            case BLANK:
                return "";
            default:
                return "";
        }
    }

    public static void main(String[] args) throws IOException {
        String xlsxFilePath = "input.xlsx"; // 替换为你的xlsx文件路径
        String csvFilePath = "output.csv"; // 替换为你的csv文件路径
        convertXlsxToCsv(xlsxFilePath, csvFilePath);
    }
}