基于批量复制的高效Excel套打方法

Efficient Excel Template-Print Based on Batch Copying

针对应用系统中广泛存在的数据报表输出问题,提出了一种基于Excel套打的方法,该方法通过批量复制和模板的动态修改,可以快速完成大数据量的报表输出。该方法的实现简单、输出的报表规范,通过性能对比实验,该方法在上万条数据记录的情况下具备良好的性能。

Many application systems face the problem of data reporting. This paper proposes one method based on Excel template-print. By batch copying and dynamic modification of Excel template, the approach can make a large amount of data reporting quick, simple and criterion. Compared with the other way by experiments, our method has good performance for processing more than ten thousand data records.