出于测试目的，在Java中模拟excel演算行为

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

public class ExcelSimulation {
    public static void main(String[] args) {
        try {
            // 创建新的Excel工作簿
            Workbook workbook = new XSSFWorkbook();

            // 创建工作表
            Sheet sheet = workbook.createSheet("Sheet1");

            // 创建单元格并设置值
            Row row1 = sheet.createRow(0);
            Cell cell1 = row1.createCell(0);
            cell1.setCellValue(10);

            Row row2 = sheet.createRow(1);
            Cell cell2 = row2.createCell(0);
            cell2.setCellValue(20);

            // 创建公式
            Cell cell3 = row2.createCell(1);
            cell3.setCellFormula("A1+A2");

            // 计算公式
            FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
            evaluator.evaluateFormulaCell(cell3);

            // 输出计算结果
            System.out.println("计算结果：" + cell3.getNumericCellValue());

            // 保存Excel文件
            FileOutputStream outputStream = new FileOutputStream("output.xlsx");
            workbook.write(outputStream);
            workbook.close();
            outputStream.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}