AutoCAD VBA与Excel在铁路横断面绘制中的应用  

Drawing Railway Cross-Sectional by Using AutoCAD VBA and Excel

作　　者：邱利群 胡友健[1] 赵雷[1] 徐文辉[1] 刘海鹏[1] 

机构地区：[1]中国地质大学信息工程学院,湖北武汉430074

出　　处：《测绘与空间地理信息》2014年第8期35-37,共3页Geomatics & Spatial Information Technology

基　　金：国家测绘地理信息局重点实验室开放基金项目(2013118006)资助

摘　　要：在铁路定测阶段,横断面测量是一项必不可少的工作,而且所需测量的横断面数量较多,因此寻找一种既符合设计单位要求的出图格式又能批量绘制铁路横断面的横断面绘制方法是很多勘测人员所面临的问题。结合工程需要,以AutoCAD为平台,开发了批量绘制横断面程序,该程序利用VBA编程控制AutoCAD读取Excel表中的横断面数据,按照设计单位指定的格式,批量绘制横断面。实践表明,该方法具有较好的实用性,提高了工作效率。Cross-section survey is an important task in the phase of railway location survey , which is needed to survey large number of cross section , so looking for a method , which can both meet the requirements of the design department and draw a railway cross sec-tional bulky , is encountered for many survey teams .Combining with the needs of project , cross-sectional drawing program is devel-oped basing on AutoCAD platform , AutoCAD is controlled by VBA to read cross -section data , draw cross-section botchy according to the format by specified design department .Application result indicated that the method has good practicability , improve work effi-ciency.

关 键 词：AUTOCAD VBA 横断面 EXCEL 铁路定测 

分 类 号：P209[天文地球—测绘科学与技术]