对Excel批量数据操作的几点研究

The Study for Batch Data Operation in Excel

本文介绍了Excel结合VB编程在报表输出方面的基本应用，并具体讲解了对Excel表格进行批量数据操作的三个方法，在不同的场合合理运用这些方法，能够在大量数据输出或实时报表打印等方面取得较为良好的效果。

This paper introduces the basic usage Excel with VB programming in the report output,and explained the three methods to Excel form batch data operation,reasonable use of these methods in different situations,and can make a more good effect for the large data output or real-time printing for report.