VBA在Excel水文数据处理中的应用研究

文中在对基于VBA在Excel水文数据处理的基础上,对水文数据的处理过程、成果数据格式及大量报表的合理统计进行了阐述,重点对VBA与Excel的交互、文件与文件数据的交互、数据的流程化管理技术做了探讨。实践表明,VBA在Excel中的开发可以对海量水文数据进行处理,在处理过程中公共参数的设置都可自动化完成,使处理速度大大地提高。

Application and research of VBA processing hydrology data in Excel

VBA is characterized by its simplicity,flexibility and powerful function,and it has become the important method of engineering calculating,data processing and data alternating presently.The processing of hydrology data,the format of the final data and the reasonable statistics of a great deal of report forms are introduced in this paper on the basis of VBA processing hydrology data in Excel,and VBA with Excel,file with file interactively,the management technology of data are mainly discussed.The practice shows that it is can realize the treatment of mass hydrology data with the parameters auto-setting based on the development of VBA in Excel.The speed of operation is greatly increased finally.