摘要
建筑物沉降变形数据量比较大,只靠人工计算既费时又费力,如果用计算机进行数据处理将会大大缩短计算时间,利用Visual Basic(VB)软件导入EXCEL数据,对导入的数据进行数据处理,并对处理数据的结果用图表表示,设计过程需要解决三个方面的问题,首先读取Excel文件,把Excel工作表里面的数据放到控件ListView里面,按照Excel工作表里面数据的格式在相应ListView里面排列出来,使操作者方便校验。其次对沉降数据点进行一定的分析,计算其每段时间每个沉降点的沉降量以及累计沉降量,通过VB把计算出来的数值在TextBox控件里显示出来。三是计算出来的结果把每段时间沉降点的沉降量趋势图在VB的Picture控件里显示出来。
The amount of building settlement deformation data is relatively large. It is time-consuming and laborious to rely on manual calculation. If the computer uses data processing, the calculation time will be greatly shortened. The EXCEL data will be imported by VB software, and the imported data will be processed and processed. The results are represented by graphs. The design process needs to solve three problems. First, read the Excel file, put the data in the Excel worksheet into the control ListView, and arrange it in the corresponding ListView according to the format of the data in the Excel worksheet. Make the operator easy to verify. Secondly, the settlement data points are analyzed to calculate the settlement and cumulative settlement of each settlement point at each time. The calculated value is displayed in the TextBox control through VB. The third is the calculated result. The settlement trend graph of the settlement point at each time is displayed in the Picture Control of VB.
作者
邓坤蕊
董燕
DENG Kun-rui;DONG Yan(Kunming University of Science and Technology, Kunming, Yunnan 650093)
出处
《软件》
2019年第2期164-168,共5页
Software
关键词
VB
EXCEL
沉降量
变形量
VB
Excel
Settlement amount
Deformation amount
