java 更新Excel内容 Excel公式未生效

最新推荐文章于 2024-05-15 08:56:53 发布

于无声处-听惊雷

最新推荐文章于 2024-05-15 08:56:53 发布

阅读量1.5k

点赞数 1

分类专栏： java 文章标签： poi excel java

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/gao_yuwushengchu/article/details/114013418

版权

问题：设置Excel的公式，根据java更新Excel中变量单元格，输出的Excel公式未生效

解决：

  //打开Excel重新计算公式
        workBook.setForceFormulaRecalculation(true);

源码如下：

 /**
     * Whether the application shall perform a full recalculation when the workbook is opened.
     * <p>
     * Typically you want to force formula recalculation when you modify cell formulas or values
     * of a workbook previously created by Excel. When set to true, this flag will tell Excel
     * that it needs to recalculate all formulas in the workbook the next time the file is opened.
     * </p>
     * <p>
     * Note, that recalculation updates cached formula results and, thus, modifies the workbook.
     * Depending on the version, Excel may prompt you with "Do you want to save the changes in <em>filename</em>?"
     * on close.
     * </p>
     *
     * @param value true if the application will per