摘要
为了降低重复性的数据操作,提高工作效率,引入利用VBA和EXCEL函数来进行编程。系统的介绍了利用VBA和EXCEL的函数如何来进行编程,指出通过WorksheetFunction对象引用Excel函数是实现动态滑动窗口的关键。通过对数据进行平滑滤波和中值滤波的分析对比得出利用Excel的函数来进行编程可提高程序的可读性,降低程序的复杂性。充分利用EXCEL具有非常强大的图像文字显示功能,可对VBA和EXCEL函数结合编程对数据的处理结果能够得到更好的分析,对从事地质和地球物理研究的人具有非常重要的意义。
In order to reduce repetitive data manipulation and improve work efficiency,VBA and EXCEL functions are combined to realize programming.The paper introduces systematically how to use VBA and EXCEL functions to programme.It points out that EXCEL function refered to WorksheetFunction is the key to achieve dynamic sliding window.Through analytic comparison with smooth filtering and median filtering,it arrives that Excel function can improve readability of the programs and reduce their complexity.With application of EXCEL which has powerful display function for picture and character,data processing result can be better and it has great significance for geological and geophysical researchers.
出处
《石油工业计算机应用》
2009年第4期9-12,共4页
Computer Applications Of Petroleum
基金
江苏省自然基金(SBK20093087)
江苏石油勘探局:局级(JD09002)