【摘要】 水布垭智能土石方平衡系统中涉及大量的报表,它们结构不一,而且都很复杂,某些报表还需要动态地根据信息来规划报表结构,如果利用VC(VisualC++)或者其他高级语言来编写,将需要利用其高级编程或者第三方报表控件,实现起来非常复杂。文中利用VBA(VisualBasicApplication)和ADO(ActiveXDataObjects)技术在Excel中生成复杂的动态报表,利用Excel现有的功能,省去了打印等工作量,提高了开发效率,取得了良好的效果。更多还原

【Abstract】 Shuibuya intelligent earthwork design system involves lots of sheets. They are all complicated and have different constructions. Furthermore, some sheets have to design construction according to the information. If use VC(Visual C++)or other high-level languages, it must use their high-level programming or other third party controls. Thus, it will turns hard. This paper introduces how to make dynamic complicated sheets in Excel by using VBA(Visual Basic Application) and ADO(Microsoft ActiveX Data Objects)technology. By using the existing function provided by Excel, much work has been omitted, such as printing, and it increases developing efficiency greatly and obtains excellent effect.更多还原