CAJ | 학술논문

在研究 POI、JXL、Jacob、JFreeChart 组件以及宏在报表输出中的优势与不足的基础上，提出 Jacob 与 POI 相结合的动态模板法。首先用 Jacob 生成只包含 chart 对象的 Excel 动态模板，然后结合 POI 读取、修改 Excel 功能写入其他信息。并充分利用 Jacob与 VBA 对 Excel 操作的相关性，方便了 Jacob 的使用，有效解决了带有 chart 复杂报表输出的问题。最后结合实例详述了动态模板法的实现过程。
재연구 POI、JXL、Jacob、JFreeChart 조건이급굉재보표수출중적우세여불족적기출상，제출 Jacob 여 POI 상결합적동태모판법。수선용 Jacob 생성지포함 chart 대상적 Excel 동태모판，연후결합 POI 독취、수개 Excel 공능사입기타신식。병충분이용 Jacob여 VBA 대 Excel 조작적상관성，방편료 Jacob 적사용，유효해결료대유 chart 복잡보표수출적문제。최후결합실례상술료동태모판법적실현과정。
We present a dynamic template method combining Jacob and POI based on studying the advantages and disadvantages of POI, JXL,Jacob,JFreeChart components and the macro in reports output.It first generates an Excelldynamic template only containing chart object with Jacob,then it combines the read and Excellmodification functions of POI to write other information.The method makes full use of the correlation of Jacob and VBA on Excelloperation,facilitates the Jacob use,and effectively solves the problem of the output of complicated report with chart.In end of the article,the implementation process of dynamic template method is expatiated on in combination with the example.