利用Excel与CAD交互性绘制溢流曲线与表格  

On Using Interactivity of Excel and CAD to Draw Overflow Curves and Tables

作　　者：张圣敏[1] 李瑞 ZHANG Shengmin;LI Rui(Yellow River Conservancy Technical Institute,Kaifeng 475004,Henan,China)

机构地区：[1]黄河水利职业技术学院,河南开封475000

出　　处：《黄河水利职业技术学院学报》2024年第4期34-38,共5页Journal of Yellow River Conservancy Technical Institute

摘　　要：针对水利工程溢流坝中溢流段曲线以及表格绘制中存在的输入坐标慢、绘图效率低等问题,提出了将Excel与CAD软件交互使用的技术方法,即将Excel文件中的坐标点数据导入CAD中,再采用CAD中的样条曲线命令(SPLINE)快速绘制曲线。分析比较了复制+粘贴法、自数据链接法(DATALINK)、复制+选择性粘贴法(PASTESPEC)将Excel表格插入CAD中效果。Aiming at the problems such as slow input of coordinates and low drawing efficiency existing in the curve and table drawing of the overflow section in hydraulic engineering overflow dams,it is proposed to interactively use Excel and CAD software.The coordinate point data in the Excel file is imported into CAD,and then the spline curve command(SPLINE)in CAD is adopted to quickly draw the curve.The effects of inserting Excel tables into CAD by means of copy+paste method,self-data link method(DATALINK),and copy+selective paste method(PASTESPEC)are analyzed and compared.

关 键 词：溢流曲线绘制 EXCEL软件 CAD软件 交互使用 表格插入 复制+粘贴法 自数据链接法 复制+选择性粘贴法 

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