JSON to Excel Documentation
来源:互联网 发布:淘宝网双11 编辑:程序博客网 时间:2024/06/17 12:43
JSON to Excel Documentation
Introduction
JSON to Excel is a Microsoft Excel add-in which can convert JSON to Excel.
Requirements
This add-in works in: Excel 2013 Service Pack 1 or later, Excel 2016 for Mac, Excel 2016 or later, Excel Online.
Quick Started
Get add-in
- Get it from Office Store link https://store.office.com/en-001/app.aspx?assetid=WA104381080
- Click on the above link and, you will see the webpage of JSON to Excel on Office Store.
- Click on the “add” button.
- The next page you will see will show that you can open the add-in in Excel/Excel Online.
- Now go to Excel 2013/2016 or Excel Online.
- JSON-to-Excel Tab > Launch JSON to Excel
- Now you are ready to use this add-in.
Use add-in
1. Prepare your JSON data
2. Fill the text area of JSON-to-Excel with your JSON data
3. Select conversion mode
3.1 Simple Mode
Note, for the simple mode, only regular JSON data can be handled. Only the keys in the first element of JSON will be interpreted as header.
Apart from the above box, nothing should be worried.
3.2 Advanced Mode
Note, for the advance mode, you must fill in the “headers for advanced mode”
Example JSON
[ { "id":1, "detail":{ "name":"David", "age":10, "sex":"male", "contact":{ "cell":139, "landline":10 } } }, { "id":2, "detail":{ "name":"May", "age":20, "sex":"female", "contact":{ "cell":158, "landline":20 } } }, { "id":3, "detail":{ "name":"Harry", "age":30, "sex":"male", "contact":{ "cell":189, "landline":10 } } }]
If you would like to have “id”,”detail.name” and “detail.sex” included , then fill in id,detail.name,detail.sex
If you would like to have “detail.name” and “detail.age” included, then fill in detail.name,detail.age
4. Click on one and ONLY one cell of the target datasheet
5. Click on “Go” button
Privacy
This Add-In will not collect and/or transmit user information. Baidu Tongji (similar to Google analytics) scripts is added for website analytics.
Disclaimer
Backup your documents before using this add-in.
About
JSON-to-Excel is an Excel add-in that convert JSON to Excel. It is maintained byhe.yang@wtsolutions.cn from WTSolutions.
© 2017, WTSolutions Blog. All rights reserved. 本文如未特别注明,均为原创文章,如需转载请注明出处。
- JSON to Excel Documentation
- Kettle Excel To JSON
- 利用xls-to-json将excel转化为json
- KnockoutJS Documentation-加载和保存json数据
- Documentation
- Documentation
- Addendum to the Xv Client library documentation
- How to read Qt documentation, basic concepts
- kbuild: Documentation - how to build external modules
- documentation refers to LinuxCNC 2.6.0
- Welcome to Swagger-PHP’s documentation!
- Google AJAX Search API Documentation (to be continue)
- How to instantiate I2C devices(From kernel-tree/Documentation/i2c)
- Linux power management: The documentation I wanted to read
- js json转excel
- nodejs:Excel导出json
- Excel转JSON
- JSON怎么转成Excel
- 第二章摘抄笔记(二)The C Programming Lanuage
- Maven项目:Spring MVC + Ajax + Json + RequestBody:POST后台服务器接收前端JSON数据并注解到POJO内
- 数据分析之Pandas(一):Series、DataFrame基本操作及索引对象
- Colorful Tree HDU
- hadoop配置
- JSON to Excel Documentation
- Git常用命令集合
- 遍历HashMap的最佳方法
- 重起myelipse的时候,发现src有个红叉
- Intellij IDEA创建包(package)问题解决方案
- The system is running in low-graphics mode ubuntu 14.04
- [比较好的博客]
- 【面试题】Netty相关
- UNIX环境高级编程读书笔记(5)