EPANET作为目前普遍使用的管网建模软件,在管网设计、运行管理方面发挥巨大的作用。然而,从CAD导入管网拓扑结构时由于缺乏管道直径属性,制约着管网建模效率。EXCEL中的VBA功能具有简单易学特点,本文通过VBA针对EPAENT管网模型拓扑结构开发的管道直径自动赋值程序简明易懂,操作便捷,大大增强了管网建模速度。 EPANET, as the commonly used pipe network modeling software, plays an important role in pipe network design and operation management. However, the lack of pipe diameter attributes when importing pipe network topologies from CAD limits the efficiency of pipe network modeling. The VBA function in EXCEL has the characteristics of easy to learn. In this paper, the pipeline diameter automatic assignment program developed by VBA for EPAENT pipe network model topology is easy to understand and easy to operate, greatly enhancing the speed of pipe network modeling.