|
|||||
|
|
| AutoCAD明细表自动导入Excel的实现方法 | |
| 引用本文： | 杜平安,李维繁新. AutoCAD明细表自动导入Excel的实现方法[J]. 工程图学学报, 2003, 24(1): 50-55 |
| 作者姓名： | 杜平安 李维繁新 |
| 作者单位： | 电子科技大学,成都,610054 |
| 摘 要： | AutoCAD是一种应用极为普遍的CAD软件，但根据存在于不同dwg文件中的明细表还无法形成产品BOM表。笔者利用ActiveX Automation技术实现AutoCAD与Excel软件的通讯。并利用VBA开发工具实现将AutoCAD的明细表自动导入到Excel中，以利用其强大的表格处理功能进行有关的表格操作并形成产品BOM表。论文介绍了ActiveX Automation技术，AutoCAD和Excel的对象层次模型，主要对象的属性及方法，以及明细表自动导入的实现方法和关键代码。 |
| 关 键 词： | AutoCAD Excel 实现方法 计算机应用 明细表自动导入 ActiveX Automation技术 数据交换 |
| 文章编号： | 1003-0158(2003)01-0050-06 |
| 修稿时间： | 2001-07-02 |
The Complementation Method of Transferring Title Block of AutoCAD into Excel |
|
| DU Ping-an LI Weifanxin. The Complementation Method of Transferring Title Block of AutoCAD into Excel[J]. Journal of Engineering Graphics, 2003, 24(1): 50-55 | |
| Authors: | DU Ping-an LI Weifanxin |
| Abstract: | 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. |
| Keywords: | computer application automatic transfer of title blook ActiveX Automation technique data exchange |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ | |