当前位置: 首页 > 文章 > Excel VBA在通信网管指标统计中的应用 河南科技学院学报(自然科学版) 2012,40 (3) 102-105
Position: Home > Articles > Application of Excel VBA to summarize communication network indicators Journal of Henan Institute of Science and Technology(Natural Science Edition) 2012,40 (3) 102-105

Excel VBA在通信网管指标统计中的应用

作  者:
陈贞
单  位:
莆田学院电子信息工程系
关键词:
Excel;VBA;Visual Basic;SQL;指标
摘  要:
通信网管指标的统计是网络维护中一项日常性的工作,对于全网级或小区级指标,可通过调用SQL脚本直接获取,但对于区域性的指标,则需对SQL的执行结果进行人工后处理,或通过频繁地修改SQL脚本来获取.引入Excel VBA并结合VB来对通信网管指标进行自动统计汇总,无需修改SQL脚本,无需后处理,操作简单,运行速度快,极大地提高了工作效率.
译  名:
Application of Excel VBA to summarize communication network indicators
作  者:
Chen Zhen(Electronic & Information Engineering Department,Putian University,Putian 351100,China)
关键词:
Excel;VBA;Visual Basic;SQL;indicator
摘  要:
Summarizing communication network indicators is a daily work in network maintenance.The network-level or cell-level indicators can be directly obtained by calling the SQL script,but for regional indicators,it is required to process executive outcomes of SQL script by manual work or to frequently modify SQL script to obtain.This paper introduces the Excel VBA combined with VB to automatically summarize the communication network indicators.It is no need to modify the SQL script or to do post-processing.The operation is simple and fast which greatly improves work efficiency.

相似文章

计量
文章访问数: 13
HTML全文浏览量: 0
PDF下载量: 0

所属期刊

推荐期刊