在Apache Poi Java中编写Excel时如何实现从科学到数值的转换

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

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;

public class ExcelConverter {
    public static void main(String[] args) throws IOException {
        String filePath = "path/to/your/excel/file.xlsx";
        Workbook workbook = new XSSFWorkbook(new FileInputStream(filePath));
        Sheet sheet = workbook.getSheetAt(0);

        for (Row row : sheet) {
            for (Cell cell : row) {
                if (cell.getCellType() == CellType.NUMERIC) {
                    double value = cell.getNumericCellValue();
                    String formattedValue = String.format("%.0f", value); // 转换为常规数值格式
                    System.out.println(formattedValue);
                    // 如果需要更新单元格的值，可以使用以下代码
                    // cell.setCellValue(Double.parseDouble(formattedValue));
                }
            }
        }

        // 保存修改后的 Excel 文件
        try (FileOutputStream fileOut = new FileOutputStream(filePath)) {
            workbook.write(fileOut);
        }
        workbook.close();
    }
}