Excel内嵌VBA和COM代码在测量计算中的应用

陈永刚; 施拥军; 汤孟平; 徐文兵

留言板

尊敬的读者、作者、审稿人, 关于本刊的投稿、审稿、编辑和出版的任何问题, 您可以本页添加留言。我们将尽快给您答复。谢谢您的支持!

姓名
邮箱
手机号码
标题
留言内容
验证码

Excel内嵌VBA和COM代码在测量计算中的应用

陈永刚 , 施拥军 , 汤孟平 , 徐文兵

文章导航 > 浙江农林大学学报 > 2008 > 25(1): 83-87

陈永刚, 施拥军, 汤孟平, 徐文兵. Excel内嵌VBA和COM代码在测量计算中的应用[J]. 浙江农林大学学报, 2008, 25(1): 83-87.

引用本文:

陈永刚, 施拥军, 汤孟平, 徐文兵. Excel内嵌VBA和COM代码在测量计算中的应用[J]. 浙江农林大学学报, 2008, 25(1): 83-87.

CHEN Yong-gang, SHI Yong-jun, TANG Meng-ping, XU Wen-bing. Measurements and calculations with embedded VBA and COM codes in Excel[J]. Journal of Zhejiang A&F University, 2008, 25(1): 83-87.

Citation:

CHEN Yong-gang, SHI Yong-jun, TANG Meng-ping, XU Wen-bing. Measurements and calculations with embedded VBA and COM codes in Excel[J]. Journal of Zhejiang A&F University, 2008, 25(1): 83-87.

Excel内嵌VBA和COM代码在测量计算中的应用

1.
浙江林学院环境科技学院, 浙江临安 311300

基金项目:

浙江省自然科学基金资助项目(Y305261);浙江林学院科研发展基金资助项目(2351000635)

详细信息

作者简介: 陈永刚,讲师,硕士,从事GIS,GPS和测量工程的应用研究。E-mail:cyg_gis@163.com

中图分类号: TB22;S771

Measurements and calculations with embedded VBA and COM codes in Excel

1.
School of Environmental Technology, Zhejiang Forestry College, Lin'an 311300, Zhejiang, China

摘要: 为了能够解决测量平差计算烦琐复杂和人工编写Cass展点文件容易出错的问题,提出一种在Excel中嵌入VBA和COM代码的方法,来简化测量平差计算且可以自动生成Cass展点文件。首先,使用VC中ATL模板开发角度转换和Cass展点COM模块;其次,在Excel中利用VBA代码调用COM模块来实现平差计算和展点文件的自动生成。在浙江林学院数字植物园的1:500大比例尺基础地形图测绘工作中,利用该方法快速准确地进行了25个点的闭合测量导线平差计算和近1.2万个展点文件的自动生成,计算结果均准确无误。该方法可使测量导线平差计算和Cass展点文件生成变得简单方便高效。
- 工程测量 /
- 测量平差 /
- 格式转换 /
- VBA代码 /
- COM模块 /
- Excel应用
Abstract: The aim is to simplify calculations of measurement adjustment and create points' files in computer assisted search service(CASS) automatically. In this study, visual basic for applications (VBA) and component object model(COM) codes were embedded into Microsoft Excel. Calculations of adjusted measurements were simplified and point files in CASS were automatically created. With this method, first COM modules with angle converts and CASS points using an active template library(ATL) template from VC were developed. Then, COM modules were used with VBA code in Excel so that measurement adjustments were calculated and point files were automatically created. This method was used for topographic measurements from 1:500 large-scale maps in the digital botanical garden of Zhejiang Forestry College with 25 points being rapidly calculated by adjustment of a closed traverse. Results revealed nearly 12 000 point files that were created automatically and accurately. With this method, complex calculating procedures were not necessary, unlike before when manually performed, and when creating the point files, mistakes were rarely made. This study showed that adjusted calculations of a closed traverse and automatic creation of point files, was relatively easy.
- engineering survey /
- survey adjustment /
- format transformation /
- visual basic for applications(VBA) /
- component object model(COM module) /
- Excel application

[1]	尹萍, 徐爱俊, 叶俊华, 夏芳, 王泽华. 基于消费级双目相机的立木因子测量方法 . 浙江农林大学学报, 2023, 40(2): 436-445. doi: 10.11833/j.issn.2095-0756.20220352
[2]	顾雯钧, 徐爱俊, 尹建新. 基于运动恢复结构的多株立木因子测量方法 . 浙江农林大学学报, 2022, 39(4): 792-799. doi: 10.11833/j.issn.2095-0756.20210547
[3]	宋博华, 高歌, 高珊, 孙琳琳, 李冰雪. 基于热技术的活立木液流测量方法综述 . 浙江农林大学学报, 2022, 39(2): 456-464. doi: 10.11833/j.issn.2095-0756.20210286
[4]	裴建川, 张书廷, 杨金艳, 张进. 立体生态模块处理杭州市玉皇山南基金小镇水体氮的效果 . 浙江农林大学学报, 2018, 35(6): 987-996. doi: 10.11833/j.issn.2095-0756.2018.06.001
[5]	管昉立, 徐爱俊. 基于智能手机与机器视觉技术的立木胸径测量方法 . 浙江农林大学学报, 2018, 35(5): 892-899. doi: 10.11833/j.issn.2095-0756.2018.05.014
[6]	邱问心, 张勇, 俞佳骏, 张超, 郑超超, 余树全. InVEST模型水源涵养模块实地应用的可行性验证 . 浙江农林大学学报, 2018, 35(5): 810-817. doi: 10.11833/j.issn.2095-0756.2018.05.004
[7]	黄兴召, 王泽夫, 徐小牛. 生物量转换因子连续函数的拟合方法比较 . 浙江农林大学学报, 2017, 34(5): 775-781. doi: 10.11833/j.issn.2095-0756.2017.05.002
[8]	莫琴, 陈志泊, 谢士琴, 陈明健, 夏朝宗. 高分辨率林业生态工程监测系统研建与应用 . 浙江农林大学学报, 2017, 34(4): 737-742. doi: 10.11833/j.issn.2095-0756.2017.04.021
[9]	高珊, 王立海, 杨冬辉, 徐文豪. Sylvatest-Duo装置的探针触式与计示压强对木材超声波测量精度的影响 . 浙江农林大学学报, 2016, 33(5): 875-880. doi: 10.11833/j.issn.2095-0756.2016.05.021
[10]	许杰, 戚大伟. 基于特征点提取的林木生长状态无损测量方法 . 浙江农林大学学报, 2016, 33(3): 403-408. doi: 10.11833/j.issn.2095-0756.2016.03.005
[11]	苏英樟, 徐文兵, 张果丽, 马灿灿, 梁丹, 方涯盼. 林区测量中全站仪无棱镜测距精度研究 . 浙江农林大学学报, 2015, 32(3): 376-383. doi: 10.11833/j.issn.2095-0756.2015.03.007
[12]	白降丽. 林业生态工程信息分类与编码体系研究 . 浙江农林大学学报, 2014, 31(4): 619-624. doi: 10.11833/j.issn.2095-0756.2014.04.019
[13]	沈宇麒, 骆林平, 阮乐华, 翁佳丽, 虞方伯, 单胜道. 太阳能集热系统与回热盘管沼气工程的应用 . 浙江农林大学学报, 2014, 31(5): 791-797. doi: 10.11833/j.issn.2095-0756.2014.05.021
[14]	余乐, 吕建雄, 李贤军, 徐康, 吴义强, 蒋佳荔. X射线扫描法和切片法测量干燥过程中杉木含水率分布的比较研究 . 浙江农林大学学报, 2013, 30(4): 543-547. doi: 10.11833/j.issn.2095-0756.2013.04.013
[15]	胡芸, 方陆明. 一种利用拓扑转换消除多边形数据压缩裂缝的方法 . 浙江农林大学学报, 2011, 28(4): 597-600. doi: 10.11833/j.issn.2095-0756.2011.04.012
[16]	陈建珍, 何超, 岳彩荣. 基于FLAASH模块的高级陆地成像仪图像的大气校正 . 浙江农林大学学报, 2011, 28(4): 590-596. doi: 10.11833/j.issn.2095-0756.2011.04.011
[17]	徐文兵, 高飞. 天宝Trimble 5800单点定位在林业测量中的应用探析 . 浙江农林大学学报, 2010, 27(2): 310-315. doi: 10.11833/j.issn.2095-0756.2010.02.025
[18]	徐文兵, 高飞, 杜华强. 几种测量方法在森林资源调查中的应用与精度分析 . 浙江农林大学学报, 2009, 26(1): 132-136.
[19]	张履勤, 章明奎. 林地与农地转换过程中红壤有机碳、氮和磷库的演变 . 浙江农林大学学报, 2006, 23(1): 75-79.
[20]	蒋文伟, 管宇, 王祖良, 潘军辉. 灰色残差GM (1 , 1)模型在大气二氧化硫预测中的应用 . 浙江农林大学学报, 2002, 19(2): 178-181.

链接本文:
https://zlxb.zafu.edu.cn/article/id/2827

https://zlxb.zafu.edu.cn/article/zjnldxxb/2008/1/83

点击查看大图

计量

文章访问数: 971
HTML全文浏览量: 226
PDF下载量: 115
被引次数: 0

Excel内嵌VBA和COM代码在测量计算中的应用

1. 浙江林学院环境科技学院, 浙江临安 311300

基金项目:

浙江省自然科学基金资助项目(Y305261);浙江林学院科研发展基金资助项目(2351000635)

作者简介:
陈永刚,讲师,硕士,从事GIS,GPS和测量工程的应用研究。E-mail:cyg_gis@163.com

收稿日期: 2007-01-10
修回日期: 2007-07-02
刊出日期: 2008-02-10

中图分类号: TB22;S771

关键词:

摘要: 为了能够解决测量平差计算烦琐复杂和人工编写Cass展点文件容易出错的问题,提出一种在Excel中嵌入VBA和COM代码的方法,来简化测量平差计算且可以自动生成Cass展点文件。首先,使用VC中ATL模板开发角度转换和Cass展点COM模块;其次,在Excel中利用VBA代码调用COM模块来实现平差计算和展点文件的自动生成。在浙江林学院数字植物园的1:500大比例尺基础地形图测绘工作中,利用该方法快速准确地进行了25个点的闭合测量导线平差计算和近1.2万个展点文件的自动生成,计算结果均准确无误。该方法可使测量导线平差计算和Cass展点文件生成变得简单方便高效。

English Abstract

Measurements and calculations with embedded VBA and COM codes in Excel

1. School of Environmental Technology, Zhejiang Forestry College, Lin'an 311300, Zhejiang, China

Received Date: 2007-01-10
Rev Recd Date: 2007-07-02
Publish Date: 2008-02-10

Keywords:

Abstract: The aim is to simplify calculations of measurement adjustment and create points' files in computer assisted search service(CASS) automatically. In this study, visual basic for applications (VBA) and component object model(COM) codes were embedded into Microsoft Excel. Calculations of adjusted measurements were simplified and point files in CASS were automatically created. With this method, first COM modules with angle converts and CASS points using an active template library(ATL) template from VC were developed. Then, COM modules were used with VBA code in Excel so that measurement adjustments were calculated and point files were automatically created. This method was used for topographic measurements from 1:500 large-scale maps in the digital botanical garden of Zhejiang Forestry College with 25 points being rapidly calculated by adjustment of a closed traverse. Results revealed nearly 12 000 point files that were created automatically and accurately. With this method, complex calculating procedures were not necessary, unlike before when manually performed, and when creating the point files, mistakes were rarely made. This study showed that adjusted calculations of a closed traverse and automatic creation of point files, was relatively easy.

陈永刚, 施拥军, 汤孟平, 徐文兵. Excel内嵌VBA和COM代码在测量计算中的应用[J]. 浙江农林大学学报, 2008, 25(1): 83-87.

引用本文:

陈永刚, 施拥军, 汤孟平, 徐文兵. Excel内嵌VBA和COM代码在测量计算中的应用[J]. 浙江农林大学学报, 2008, 25(1): 83-87.

CHEN Yong-gang, SHI Yong-jun, TANG Meng-ping, XU Wen-bing. Measurements and calculations with embedded VBA and COM codes in Excel[J]. Journal of Zhejiang A&F University, 2008, 25(1): 83-87.

Citation:

CHEN Yong-gang, SHI Yong-jun, TANG Meng-ping, XU Wen-bing. Measurements and calculations with embedded VBA and COM codes in Excel[J]. Journal of Zhejiang A&F University, 2008, 25(1): 83-87.