摘要
利用MicrosoftExcel制表、统计、计算准确快捷和AutoCAD绘图方便实用的优点,充分发挥两者的优势,将MicrosoftExcel的表格转换到AutoCAD图形中.在AutoCAD中可以方便地对表格的内容进行编辑修改,形成图文并茂的设计图纸.转换的方法是利用AutoCAD提供的VBA接口程序,将表格线条、表格内容按照原样绘制在AutoCAD图形中.转换的基本方法是通过读取MicrosoftExcel各单元格四个边框和caption属性来确定AutoCAD中每个单元格边框粗细和文字内容、位置,在AutoCAD中利用VBA绘制多意线的命令AddlightWeight-Polyline绘制表格线框,利用文本标注命令AcadMtext和AcadText实现文字的标注.
The contents of forms are edited and a mended,and design blueprints with g raphs and words are formed in AutoCAD,by making full use of good points of Mi crosoft Excel's functions of making forms,statistic,calculating quickly and exactly,and those of Autocad's convenient and practical graphing.The way to transform is to use the VBA connecting programs offered by Autocad to draw the lines and content s of forms as its original ones into graphs of Autocad.The basic way to tran sform is to confirm the contents of words and thi ckness of the frame of each unit of Aut ocad by reading through four frames o f each unit of Microsoft Excel,to draw frames of fo rms by using the addlightWeightPoly line order of VBA to draw multi -meani ng lines ,and to realize the marking of words by using the AcadMtext order and the AcadText order.
出处
《宁夏工程技术》
CAS
2003年第1期76-80,共5页
Ningxia Engineering Technology
