摘要
杭长高铁多处地段位于路基和桥梁结合处,为无砟地段,因异常变形影响,需布设监测断面开展沉降变形监测工作。沉降监测需要同步对各地段开展一期CPIII控制网进行监测,各处重点地段根据异常变形位置,各向两侧延长200 m左右布设断面监测点,布设之后需要对各监测点的周期性沉降变形监测数据进行采集并处理。监测数据周期为一个月左右,产生的数据量比较大。本文根据实际生产需要,在Visual Studio 2010中采用C#编程语言,通过引用Office的Interop组件技术,将txt文本导入Excel中,并且在Excel中生成线状图,大大提高了生产作业的效率,减少了人工操作的工作量,具有较强的实用性。
Many sections of Hangzhou Changsha high-speed railway are located at the junction of subgrade and bridge, which are Ballastless sections. Due to the influence of abnormal deformation, it is necessary to lay monitoring sections to carry out settlement deformation monitoring. For settlement monitoring, the first phase CPIII control network of each section needs to be carried out simultaneously. According to the abnormal deformation position, the section monitoring points are arranged in each key section, extending about 200 meters on both sides. After the arrangement, the periodic settlement deformation monitoring data of each monitoring point needs to be collected and processed. The monitoring data cycle is about one month, and the amount of data generated is relatively large. According to the actual production needs, this paper uses C# programming language in Visual Studio 2010, imports the TXT text into excel by quoting the Interop component technology of Microsoft Office, and generates the line chart in Excel, which greatly improves the efficiency of production, reduces the workload of manual operation, and has strong practicability.
作者
姚国纪
郝景莹
王晓波
YAO Guoji;HAO Jingying;WANG Xiaobo(The Second Geodetic Surveying Brigade,Ministry of Natural Resources,Harbin 150025,China;Harbin Institute of Technology Software Engineering Co.,Ltd.,Harbin 150023,China)
出处
《测绘与空间地理信息》
2022年第S01期282-285,共4页
Geomatics & Spatial Information Technology