利用OLE技术和Excel制作复杂报表

Complicated Report Generation Using OLE and Excel

论述了在VisualBasic6.0中利用OLE(ObjectLinkingEmbeddingAutomation)技术和Excel制作复杂报表的一种方法。利用这种方法,不仅可以在程序中直接控制Excel应用程序,将数据库中的数据直接输入到Excel中,产生工作簿,实现存储和打印,而且还可以对生成的Excel表格进行详细的格式控制,生成满足用户要求的复杂报表,生成后的报表还可以利用Excel的强大功能进行二次修改。详细介绍了实现的原理及实现的具体过程。

A method to generate complicated reports by using OLE and Excel in Visual Basic 6.0 programming is presented. By using this method, the Excel application can be directly controlled in programming, and the data in the database can be directly input to Excel to produce workbooks and realize the storage and printing. Also the format of the acquired excel worksheets can be controlled in detail and generate the complicated report to satisfy the users. The generated worksheets can be modified for the second time by using the powerful function of Excel. The principle and procedure are explained in details.