用VB从A文件提取雷电资料并写入EXCEL表  

Extracting Lightning Data from Files and Writing Data to Excel Worksheet by Using VB

作　　者：刘红坤[1] 贾琳[1] 高霞[1] 顾黎燕 

机构地区：[1]河北省保定市气象局,河北保定071000

出　　处：《安徽农业科学》2014年第23期7937-7938,共2页Journal of Anhui Agricultural Sciences

摘　　要：做雷电研究需要地面气象数据资料,而现有的地面气象资料以文本形式存在,无法进行数据查询、统计、计算等,因而不能满足雷电统计及相关性分析的需求。为了解决此问题,利用Visual Basic 6.0编程实现了自动从地面气象观测数据文件(简称为A文件)中提取雷暴等所需数据并写入Excel表的功能,提取结果可按单站、单要素输出,从而为雷电研究提供了可操作的基础气象数据,为雷电服务工作提供了便利。Lightning research needs the surface meteorological data, but the present surface meteorological data exists by text form, the query, statistics, calculation of data can＇ t be done. So that it can＇ t meet the needs of lightning statistics and correlation analysis. In order to solve this problem, the function of automatically extracting the thunderstorm data and so on from the surface meteorological data files（ short for A files） and writing data to Excel worksheet is realized by using the Visual Basic 6.0. The extraction results are outputted according to single station or single factor. So it will provide operational and basic meteorological data ibr lightning research, provide the convenience for lightning service.

关 键 词：VB A文件 雷电资料 提取 EXCEL 

分 类 号：S161[农业科学—农业气象学]