节水灌溉设计中基于AutoCAD VBA的程序开发与应用

Program Development and Application Based on AutoCAD VBA in Water-Saving Irrigation Design

在节水灌溉工程的设计中,对于管线高程点与长度的读取工作常常较为繁琐和枯燥。利用VBA对AutoCAD进行程序的二次开发和应用,从而实现准确快捷地读取每条管线的高程值和管线长度,并将数据导出至Excel当中。该程序的运用将显著提高工程量统计的效率,可以在类似的工作环境中加以推广,并为后续的再次开发或完善提供有力的支撑。

In water-saving irrigation engineering design, the work of reading and writing the data ot elevation ano rne tengm ol pLpe- line is always cumbersome and tedious. In this paper, secondary development for AutoCAD program is conducted through using VBA to read and write the data of elevation and length of every pipe accurately and swiftly, and directly write them into Excel file. The application of the program will enhance the efficiency of the statistics work. It can be popularized in similar environment. What ＂s more, it provides a vigorous supporting for the next development or perfectiorL