在Excel中导入Json [英] Import Json in Excel
问题描述
此链接上的代码将JSON导入到Google文档电子表格工作簿中 https://github.com/fastfedora/google-docs/blob/master/scripts/ImportJSON/Code.gs 。有没有excel的等价物,所以我可以从网站上的JSON获得某些值?它需要是XML吗?
The code on this link imports JSON into a google docs spreadsheet workbook https://github.com/fastfedora/google-docs/blob/master/scripts/ImportJSON/Code.gs. Is there any excel equivalent so I can get certain values from JSON on a website? Does it need to be XML?
推荐答案
在我的搜索过程中,我找不到太多解决方案,用于简单的JSON来优化转换工具/代码。所以我开发了一个基本上以树形式表示JSON文件的VBA脚本,从而允许用户选择如何将JSON转换为表格视图。
脚本驻留在此处 https://github.com/ronle/JsonToExcel
During my searches I couldn't find too many solutions for simple JSON to excel conversion tools / codes. So I developed a VBA script that basically represents the JSON file in tree format thus allowing the user to select how to translate the JSON into tabular view. Script is hosted in here https://github.com/ronle/JsonToExcel
希望你觉得有用。
这篇关于在Excel中导入Json的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!