基于Auto CAD VBA获取河长的研究

Studies on Obtaining the Length of River Based on Auto CAD VBA

水文流域参数是进行各项水文分析计算的基础数据,河长比降是基本的水文流域参数,比降的计算还需获取分段河长。目前依靠传统的Auto CAD获取河长有两种方法,但两种方法存在不足,都依赖人工,不能实现Auto CAD与EXCEL数据的快捷与直接传递。文中基于VBA研制出获取河长软件,应用实例对三种方法进行比较,通过比较得出,VBA实现了批量将河长数据快速直接地导入EXCEL,提高了工作效率。

The hydrologic parameters including the length and gradient of river are basic data for hydrologic analysis and calculation, in which it is need to obtaining the segment length of a river to calculate the gradient of a river. At present, there are two methods to obtain the length of a river based on conventional methods of Auto CAD, which are so defective and artificial that they can't realize fast and immediate transfer between Auto CAD and EXCEL. This paper carries on studies on obtaining the length of a river based on Auto CAD VBA. Then three methods are compared with the actual case and the result shows that VBA realizes fast and immediate data transfer between Auto CAD and EXCEL and at last improves work efficiency.