Abstract: Modeling of arch dam is growing more and more difficult as its complex shape. To get the required coordinates of arch dam modeling, this paper does secondary development of Excel by VBA. And acquired coordinates could generate executable APDL code, which would make establishing double-curvature arch dam model more quickly and efficiently. It could save a lot of time for the next simulation analysis and calculation of arch dam. The result shows that the parameterized modeling of arch dam becomes more convenient and accurate by the method combining Excel-VBA and APDL.

Key words: Excel-VBA, ANSYS-APDL, arch dam, parametric modeling

摘要： 由于拱坝体形较为复杂，拱坝建模难度较大。笔者利用VBA对Excel进行二次开发，得出拱坝建模中所需的点坐标。根据这些点坐标生成ANSYS中可执行的APDL代码，快捷高效地建立了双曲拱坝模型，为此后的拱坝仿真计算创造了条件。实例表明，Excel-VBA与APDL的结合使用，可以使ANSYS中拱坝的参数化建模更为方便和准确。

关键词: Excel-VBA, ANSYS-APDL, 拱坝, 参数化建模