摘要
针对水利灌浆工程灌浆成果表整理工作量大、效率低的问题,提出运用Excel的二次开发工具VBA语言编写程序、将可视化窗口作为操作界面的方法,实现灌浆成果表的自动整理。将原始钻孔资料与灌浆资料录入Excel工作表,在可视化窗口中选择需要进行整理的表名,单击生成表格命令按钮即可自动完成成果表整理。工程实例结果表明:该程序可实现灌浆表的自动、准确、高效整理。为Excel VBA语言应用于灌浆工程资料整理的进一步开发奠定了基础,同时也为其它工程资料整理提供了科学的参考。
Abstract
Heavy workload and low efficiency are problems in organizing the grouting result tables of water conservancy grouting projects. In this paper, taking visualization window as the operation interface, a program for automatically organizing the grouting result tables using VBA language, the secondary development tool of Excel, is presented. Having inputted original borehole data and the grouting data in the Excel worksheets, users then select tables to be organized in the visualization window, and then click on “generate table” button to achieve automatic organization. The program has been applied to an engineering project and proved to be capable of automatic, accurate, and efficient organization. This paper lays foundation for applying Excel VBA language to organizing data of grouting projects, and serve as a reference for organizing data of other engineering projects.
关键词
灌浆成果表  /
Excel  /
VBA语言
Key words
grouting result table /
excel /
VBA language
刘慧霞,向红利.
基于Excel VBA的灌浆成果表整理程序的开发[J]. 长江科学院院报. 2011, 28(5): 71-74
LIU Hui-xia,XIANG Hong-li.
Programming of Organizing Grouting Result Tables Using VBALanguage Based on Excel Software [J]. Journal of Changjiang River Scientific Research Institute. 2011, 28(5): 71-74
{{custom_sec.title}}
{{custom_sec.title}}
{{custom_sec.content}}