Excel在AutoCAD参数化绘图中的应用  

Application of Excel in AutoCAD Parametric Drawing

作　　者：余亮平 YU Liang-ping(Wuhuan Engineering Co.,Ltd.,Wuhan Hubei 430223,China)

机构地区：[1]中国五环工程有限公司,湖北武汉430223

出　　处：《化肥设计》2020年第4期26-30,共5页Chemical Fertilizer Design

摘　　要：在工程设计中,重复繁琐的工程图形,人工绘图工作量大、效率低,同时也易出错。若能将图形以参数化方式生成,不仅可提高工作效率,还能保证图纸输出质量。介绍了一种参数化绘图方法(本文称之为"表格绘图法"),将Excel表格应用于AutoCAD工程绘图,可实现图形的快速自动生成。表格绘图法作为一种创新的绘图方法,可按照具体工程要求自定义绘图条件和输出内容,具备高效、精确、实用等优点,适用于各类工程图形的绘制,尤其在大量重复度较高的图形绘制方面,具有很好的工程应用意义。In engineering design,drawing engineering graphics is a repetitive and tedious task,and manual drawing features large work quantity,low efficiency as well as error-proneness.If graphics can be generated with only necessary parameters,it can not only lead to enhanced work efficiency but also to more consistent drawing output quality.In this paper,a parameterized drawing method(called"Excel drawing method"herein)is introduced,which applies Excel tables in AutoCAD engineering drawings for rapid and automatic generation of graphics.As an innovative drawing method,this Excel drawing method can customize drawing conditions and output contents according to specific engineering requirements,demonstrating such advantages as high efficiency,high precision and great practicality,and is thus suitable for drawing all kinds of engineering graphics,large numbers of highly repetitive graphics in particular.This is,therefore,of very good engineering application significance.

关 键 词：表格绘图法 参数化绘图 EXCEL AUTOCAD 自动生成 

分 类 号：TP391.72[自动化与计算机技术—计算机应用技术]