| Excel VBA在测量数据处理中的应用 |
| |
| 引用本文： | 王汉雄,乔景顺.Excel VBA在测量数据处理中的应用[J].测绘科学,2008,33(2):210-212. |
| |
| 作者姓名： | 王汉雄 乔景顺 |
| |
| 作者单位： | 黄淮学院建筑工程系,河南驻马店,463000 |
| |
| 摘 要： | Excel是office办公软件中的一个组件,而VBA是office应用程序共享的一种通用的自动化语言,可以使常用的office应用程序自动化,并可以创建自定义的解决方案。本文对Excel2003的数据处理功能进行分析,论述通过Excel2003的VBA编辑器创建"宏"功能实现测量数据处理的优点;并结合道路工程中桩坐标及其放样数据计算实例,给出了通过VBA编程进行测量数据处理的方法。
|
| 关 键 词： | 工程测量 数据处理 Excel VBA 宏 程序编制 |
| 文章编号： | 1009-2307（2008）02-0210-03 |
| 收稿时间： | 2007-01-12 |
| 修稿时间： | 2007年1月12日 |
Application of Excel VBA in data processing of engineering surveying |
| |
| WANG Han-xiong,QIAO Jing-shun.Application of Excel VBA in data processing of engineering surveying[J].Science of Surveying and Mapping,2008,33(2):210-212. |
| |
| Authors: | WANG Han-xiong QIAO Jing-shun |
| |
| Abstract: | Excel is a groupware of the Microsoft office software, and VBA is one of current automatic language in office application program sharing, which can make common program more automatically running, and can establish some user-defined solusions. This paper analyses the data processing function of Excel 2003, and emphasizes on the discussion of "macro" edited by VBA of Excel 2003 to perform surveying data processing. Based on the calculated examples of the middle pile coordinate and the surveying data of road construction, the paper explains the characteristics and advantages of data processing with VBA, and gives a convenient and intuitionistic method in dealing with the surveying data. |
| |
| Keywords: | engineering survey data processing Excel VBA macro programming |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
