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

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

摘要: 针对水利工程溢流坝中溢流段曲线以及表格绘制中存在的输入坐标慢、绘图效率低等问题, 提出了将Excel与CAD软件交互使用的技术方法, 即将Excel文件中的坐标点数据导入CAD中, 再采用CAD中的样条曲线命令(SPLINE)快速绘制曲线。分析比较了复制+粘贴法、自数据链接法(DATALINK)、复制+选择性粘贴法(PASTESPEC)将Excel表格插入CAD中效果。

Abstract: 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.