How JSON is exported as Excel
The JSON content is as follows:
[{"Ztdid": "100000", "Ztdno": "001", "Ztdname": "Shop 1th", "Address": "XX City, ZZ District, No. No. 01 yy Road Shop", "Remark": "," Areaid ":" "," Ztdtel ": "0000-8888888", "ztdcontact": "Zhang San"},{"Ztdid": "100001", "Ztdno": "002", "Ztdname": "Shop 1th", "Address": "XX City, ZZ District, No. 01 yy Road Shop", " Remark ":", "Areaid": "," "Ztdtel": "0000-8888888", "ztdcontact": "Lie Triple"}]
JSON parses and outputs Excel
Share to:
------Solution--------------------
Format the array first, and then you can build it with some classes that generate Excel, such as http://code.google.com/p/php-excel/
------Solution--------------------
Phpexcel or some other lightweight plugin to generate Excel
------Solution--------------------
Turn JSON into data first, Json_decode
Then generate Excel and put the input in the array into