| 基于Excel VBA的灌浆成果表整理程序的开发 |
| |
| 引用本文： | 刘慧霞,向红利.基于Excel VBA的灌浆成果表整理程序的开发[J].长江科学院院报,2011,28(5):71-74. |
| |
| 作者姓名： | 刘慧霞 向红利 |
| |
| 作者单位： | 衢州市水利水电勘测设计有限公司，浙江 衢州 324002 |
| |
| 摘 要： | 针对水利灌浆工程灌浆成果表整理工作最大、效率低的问题,提出运用Excel的二次开发工具VBA语言编写程序、将可视化窗口作为操作界面的方法,实现灌浆成果表的自动整理.将原始钻孔资料与灌浆资料录入Excel工作表,在可视化窗口中选择需要进行整理的表名,单击生成表格命令按钮即可自动完成成果表整理.工程实例结果表明:该程序可实...
|
| 关 键 词： | 灌浆成果表 Excel VBA语言 |
Programming of Organizing Grouting Result Tables Using VBA Language Based on Excel Software |
| |
| LIU Hui-xia,XIANG Hong-li.Programming of Organizing Grouting Result Tables Using VBA Language Based on Excel Software[J].Journal of Yangtze River Scientific Research Institute,2011,28(5):71-74. |
| |
| Authors: | LIU Hui-xia XIANG Hong-li |
| |
| Affiliation: | Quzhou Water Resource and Hydropower Design and Research Co.Ltd. ，Quzhou 324002，China |
| |
| 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 genera... |
| |
| Keywords: | grouting result table excel VBA language |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
| 点击此处可从《长江科学院院报》浏览原始摘要信息 |
|
点击此处可从《长江科学院院报》下载全文 |
