AutoCAD明细表自动导入Excel的实现方法

The Complementation Method of Transferring Title Block of AutoCAD into Excel

AutoCAD是一种应用极为普遍的CAD软件,但根据存于不同dwg文件中的明细表还无法形成产品BOM表。笔者利用ActiveX Automation技术实现AutoCAD与Excel软件的通讯。并利用VBA开发工具实现将AutoCAD的明细表自动导入到Excel中,以利用其强大的表格处理功能进行有关的表格操作并形成产品BOM表。论文介绍了ActiveX Automation技术,AutoCAD和Excel的对象层次模型,主要对象的属性及方法,以及明细表自动导入的实现方法和关键代码。

AutoCAD is a wide-used CAD software, but the BOM of a product cannot be formed based on the title blocks of assembly drawings that are saved in different dwg files. In this paper, ActiveX Automation technique is used to realize the communication between AutoCAD and Excel, and VBA development tool is adopted to implement the automatic transferring of the title block in AutoCAD into Excel, in which some manipulations on tables can be completed conveniently and the BOM will be formed. The ActiveX Automation technique, the object model of AutoCAD and Excel, the attributes and methods of some primary objects are introduced, and finally the complementation method of the automatic transferring and key codes are presented in this paper.