首页 | 本学科首页   官方微博 | 高级检索  
     检索      

ExcelVBA开发渠道纵断面图辅助绘图程序实践与探讨
引用本文:董文明,马英杰,崔龙,孔德庸.ExcelVBA开发渠道纵断面图辅助绘图程序实践与探讨[J].新疆农业大学学报,2009,32(1):89-92.
作者姓名:董文明  马英杰  崔龙  孔德庸
作者单位:1. 新疆农业大学,水利与土木工程学院,乌鲁木齐,830052
2. 中国农业大学,资源与环境学院,北京,100094
基金项目:新疆水利水电工程重点学科基金 
摘    要:使用Excel的VBA编程功能,将设计好的数据自动的输出为AutoCAD的命令组文件(Script),在AutoCAD里运行该命令组文件,即可快速的绘制渠道纵断面图,使用该程序时,还可根据各项目的特点修改局部参数和预设图框内容,直接批量生成施工图,极大程度上减化了渠道设计人员的绘图工作。

关 键 词:Excel  Auto  CAD  VBA编程  渠道纵断面图绘图  传统绘图方法

Practice and Discussion on Auxiliary Drawing Routine of Excel VBA Development Channel Profile Diagram
DONG Wen-ming,MA Yin-jie,CUI Long,KONG De-yong.Practice and Discussion on Auxiliary Drawing Routine of Excel VBA Development Channel Profile Diagram[J].Journal of Xinjiang Agricultural University,2009,32(1):89-92.
Authors:DONG Wen-ming  MA Yin-jie  CUI Long  KONG De-yong
Institution:DONG Wen-ming , MA Yin-jie , CUI Long, KONG De-yong (1. College of Water Conservancy and Civil Engineering, Xinjiang Agricultural University, Urumqi 830052; 2. College of Resources and Environment Science,China Agricultural University,Beijing 100094)
Abstract:In this paper, it introduces an improved way to help us to finish canal profile diagram. The way,with the help of VBA programs in Excel to make Script files which can be run in AutoCAD,can help us to finish the canal profile diagrams easily when we design canals. When programing function was made using Excel VBA,the designed data were automatically output for the commond group of Auto CAD files (Script) ,then a channel Profile diagram could immediately be finished. When using the program, it could be modified in accordance with the purpose of the characteristics of local map pre-set parameters and content of the box. Directly the working drawing could be produced on a large scale which could decrease drawing work of channel designers to a great exteat.
Keywords:Excel  Auto CAD
本文献已被 维普 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号