基于VBA的CIM/XML的电网模型解析与转换  

CIM/XML Power Grid Model Parsing and Transformation Based on VBA

作　　者：戴乔旭 罗宗杰 DAI Qiaoxu;LUO Zongjie(Zhanjiang Power Supply Bureau of Guangdong Power Grid Co.,Ltd.,Zhanjiang 524001,China)

机构地区：[1]广东电网有限责任公司湛江供电局,广东湛江524001

出　　处：《现代信息科技》2022年第19期64-66,共3页Modern Information Technology

基　　金：广东电网职工创新项目(GDZC202202281384)。

摘　　要：电力系统的模型数据在不同系统软件中传输具有重要意义,现主要采用IEC61970标准中的公共信息模型(CIM)结合可扩展标记语言(XML)实现对电力系统模型的构建与传输。而JSON与XML作为现今互联网最常用的两种数据交换格式,JSON比XML更为简洁、处理速度更快、占用CPU资源更少,在互联网数据交换时具有更大优势。文章基于VBA编程语言,通过宿主WPS表格软件自带的DOM文档处理工具解析CIM/XML模型,提取电力系统模型的关键信息生成更为简洁的JSON数据格式。所编制的转换工具通过在南网智瞰平台的实际应用验证了转换数据工具的可行性。The transmission of model data of power system in different system software is of great significance,and the common information model(CIM)in the IEC61970 standard is mainly used to build and transmit the power system model in combination with extensible markup language(XML).JSON and XML,as the two most commonly used data exchange formats on the today’s Internet,JSON is more concise than XML,faster in processing,occupies less CPU resources,and has greater advantages in Internet data exchange.Based on the VBA programming language,this paper analyzes the CIM/XML model through the DOM document processing tool included in the host WPS tabular software,extracts the key information of the power system model and generates a more concise JSON data format.The proposed conversion tool verifies the feasibility of the data conversion tool through the practical application in the China Southern Network Zhikan platform.

关 键 词：VBA CIM XML JSON 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]