道路横断面数据转换工具设计与开发实现

Design and Development of Road Cross Section Data Conversion Tool

针对道路横断面格式多样,现有软件和研究成果不能完全满足格式之间的转换问题,本文基于VSTO对EXCEL进行二次开发,实现南方CASS格式到常见的四种横断面格式之间的转换,并实现横断面数据常见错误的检查和修改。将该道路横断面数据转换工具应用于莆田市荔城区延寿溪及其支流安全生态水系建设(一期)项目,验证该工具软件正确有效,可供相关工程项目的横断面格式转换参考。

In view of the diversity of road cross section formats,the existing software and research results can not fully meet the problem of conversion between formats.Based on VSTO,EXCEL is re developed to realize the conversion from the southern CASS format to the four common cross section formats,and realize the inspection and modification of common errors in cross section data.The tool is applied to the construction of safe ecological water system of Yanshou River and its tributaries(Phase I)in Licheng District,Putian City,to verify that the tool software is correct and effective,which can be used as a reference for cross section format conversion of related engineering projects.