json到vba数组 [英] json to vba array

问题描述

我需要将json字符串转换为VBA数组...

I need to convert a json string to VBA Array...

json：

{" General"：{" Brand"：[" A-DATA"" ZTE"，" ZyXel"]，""""""" Type" ：["电缆"，"路由器"，"交换机"，"数据卡"，"接入点"，"投影仪
服务器"，"内部调制解调器"，"无线USB适配器" ;，"网络接口卡"，"Range Extender& "中继器"，"具有调制解调器的无线路由器"，"网络访问存储（NAS）"，"无线路由器
无调制解调器"，"颜色"：["黑色"，"白色"和"白色"。 ，"灰色"，"其他"，"速度"：["21Mbps"，"24Mbps"，"54Mbps"，"108Mbps"，"150Mbps"，" 200Mbps"，"270
Mbps"，"300Mbps"，"450Mbps"，"1300Mbps"，"1600Mbps"，"LED指示器"：""， "部件号"："""，"尺寸"：{" Height"：""，" Width"：""，"""""""""

加密"：""""，"安全"：{"防火墙"：""，"加密"：""，"其他安全功能"： "连接"："无USB端口"：["1"，"2"，"3"，"4"，"5&quo" t;，"6"，"Antennae"：["1"，"2"，"3"，"4"]，"LAN"：""，"Number" b $ b LAN端口"：""，" Frequency"：""，" LAN \ / WAN"：""，" WAN of WAN ports"""" "标准IEEE"：" - "，"操作条件"：{"电源"：""，"运行
湿度"：""，"操作系统"，"操作系统"和"操作系统"。 ："""，"Temperature"："""，"其他功能"：{" Certification"：""，" Controls"："""""" SSID Support"： """，"Service
类型"：""}，"In The Box"：{" Sales Package"：""}，"""Warranty"：{" Period" ;：""，" Type"：""}

{"General":{"Brand":["A-DATA""ZTE","ZyXel"],"Model":"","Type":["Cables","Routers","Switches","Data cards","Access Points","Projector Servers","Internal Modems","Wireless USB Adapters","Network Interface Cards","Range Extender & Repeater","Wireless Router With Modem","Network Access Storage (NAS)","Wireless Router Without Modem"],"Colour":["Black","White","Grey","Other"],"Speed":["21 Mbps","24 Mbps","54 Mbps","108 Mbps","150 Mbps","200 Mbps","270 Mbps","300 Mbps","450 Mbps","1300 Mbps","1600 Mbps"],"LED Indicator":"","Part Number":""},"Dimensions":{"Height":"","Width":"","Depth":"","
Encryption":""},"Security":{"Firewall":"","Encryption":"","Other Security Features":""},"Connectivity":{"No~ of USB Ports":["1","2","3","4","5","6"],"Antennae":["1","2","3","4"],"LAN":"","Number of LAN ports":"","Frequency":"","LAN\/WAN":"","Number of WAN ports":"","Standard IEEE":""},"Operating Conditions":{"Power Supply":"","Operating Humidity":"","Operating System":"","Temperature":""},"Additional Features":{"Certification":"","Controls":"","SSID Support":"","Service Type":""},"In The Box":{"Sales Package":""},"Warranty":{"Period":"","Type":""}

推荐答案

使用
ScriptControl 。

这篇关于json到vba数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！