JSON串转为excel

最新推荐文章于 2024-05-03 10:30:24 发布
最新推荐文章于 2024-05-03 10:30:24 发布
阅读量3.5k 收藏 1
点赞数 2
文章标签： json excel java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yelinlan/article/details/130422432
版权

JSON转为Excel

import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;
import cn.hutool.json.JSONUtil;
import com.alibaba.excel.EasyExcel;
import org.junit.jupiter.api.Test;

import java.util.ArrayList;
import java.util.Comparator;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Objects;

public class JSON2Excel {
	public static final String FILE_NAME = "json导出excel.xls";
	public static final String SHEET_NAME = "default";
	private final Map<Integer, Map<Integer, String>> pos = new HashMap<>();
	private int row = 0;

	@Test
	public void test() {
		String json = getJsonStr();
		//转换json
		System.out.println(json);
		JSON obj = JSONUtil.parseObj(json);
		//记录所有键值坐标位置Map
		fillMap(obj, 0);
		//根据Map坐标转换为二维数组
		List<List<String>> exportList = buildExcelExportList(pos);
		//导出
		EasyExcel.write(FILE_NAME).sheet(SHEET_NAME).doWrite(exportList);
	}

	/**
	 * Map递归记录
	 */
	private void fillMap(Object obj, int depth) {
		int col = depth;
		if (obj instanceof JSONObject) {
			for (Map.Entry<String, Object> entry : ((JSONObject) obj)) {
				//记录键
				setPos(row, col, entry.getKey());
				row++;
				//下一层
				depth++;
				fillMap(entry.getValue(), depth);
				depth--;
			}
		} else if (obj instanceof JSONArray) {
			for (Object val : ((JSONArray) obj)) {
				//如果是数组里的普通的值,就下一行,避免覆盖。
				if (!(val instanceof JSON)) {
					row++;
				}
				fillMap(val, depth);
			}
		} else {
			//把值填到key:val 的val里
			row--;
			setPos(row, col, Objects.toString(obj, ""));
			row++;
		}
	}

	/**
	 * Map记录坐标
	 */
	public void setPos(int row, int col, String val) {
		pos.computeIfAbsent(row, k -> new HashMap<>());
		pos.get(row).put(col, val);
	}

	/**
	 * Map坐标转二维数组
	 */
	public List<List<String>> buildExcelExportList(Map<Integer, Map<Integer, String>> posType) {
		int maxI = getMaxI(posType);
		int maxJ = getMaxJ(posType);
		List<List<String>> excelList = new ArrayList<>(maxI);
		for (int i = 0; i < maxI; i++) {
			List<String> columnList = new ArrayList<>(maxJ);
			for (int j = 0; j < maxJ; j++) {
				String val = null;
				if (posType.get(i) != null) {
					val = posType.get(i).get(j);
				}
				columnList.add(j, val);
			}
			excelList.add(columnList);
		}
		return excelList;
	}

	/**
	 * 获取行size
	 */
	private static Integer getMaxI(Map<Integer, Map<Integer, String>> m) {
		return m.keySet().stream().max(Comparator.naturalOrder()).get() + 1;
	}

	/**
	 * 获取列size
	 */
	private static Integer getMaxJ(Map<Integer, Map<Integer, String>> m) {
		return m.values().stream().map(p -> p.keySet().stream().max(Comparator.naturalOrder()).get())
				.max(Comparator.naturalOrder()).get() + 1;
	}

	public static String getJsonStr() {
		return "";
	}
}

结果

在这里插入图片描述

依赖

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>3.2.1</version>
        </dependency>
        <dependency>
            <groupId>cn.hutool</groupId>
            <artifactId>hutool-all</artifactId>
            <version>5.8.15</version>
        </dependency>

样例

{
	"status": 0,
	"message": "",
	"data": {
		"search_data": [
			{
				"elements": ["还是数组",
					["数组1","数组1","数组1","数组1","数组1","数组1"]
					,{
						"rating": 0,
						"name": "奈良市",
						"url": "/scenic/3/10052/",
						"wish_to_go_count": 328,
						"name_orig": "奈良市",
						"visited_count": 1958,
						"comments_count": 0,
						"location": {
							"lat": 34.685087,
							"lng": 135.805
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "奈良市",
						"name_en": "Nara",
						"type": 3,
						"id": 10052,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					},
					{
						"rating": 0,
						"name": "小樽市",
						"url": "/scenic/3/26772/",
						"wish_to_go_count": 266,
						"name_orig": "小樽市",
						"visited_count": 954,
						"comments_count": 0,
						"location": {
							"lat": 43.190717,
							"lng": 140.994662
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "小樽市",
						"name_en": "Otaru",
						"type": 3,
						"id": 26772,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					},
					{
						"rating": 0,
						"name": "槟城",
						"url": "/scenic/2/8257/",
						"wish_to_go_count": 93,
						"name_orig": "槟城",
						"visited_count": 849,
						"comments_count": 0,
						"location": {
							"lat": 5.414167,
							"lng": 100.328759
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "槟城",
						"name_en": "Penang",
						"type": 2,
						"id": 8257,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/province.png"
					},
					{
						"rating": 0,
						"name": "墨尔本",
						"url": "/scenic/3/47810/",
						"wish_to_go_count": 2927,
						"name_orig": "墨尔本",
						"visited_count": 2112,
						"comments_count": 0,
						"location": {
							"lat": -37.814216,
							"lng": 144.963231
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "墨尔本",
						"name_en": "Melbourne",
						"type": 3,
						"id": 47810,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					},
					{
						"rating": 0,
						"name": "广岛县",
						"url": "/scenic/2/9474/",
						"wish_to_go_count": 36,
						"name_orig": "广岛县",
						"visited_count": 160,
						"comments_count": 0,
						"location": {
							"lat": 34.39656,
							"lng": 132.459622
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "广岛县",
						"name_en": "Hiroshima Prefecture",
						"type": 2,
						"id": 9474,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/province.png"
					},
					{
						"rating": 0,
						"name": "泰国",
						"url": "/scenic/1/3649/",
						"wish_to_go_count": 22131,
						"name_orig": "泰国",
						"visited_count": 22298,
						"comments_count": 0,
						"location": {
							"lat": 15.870032,
							"lng": 100.992541
						},
						"has_experience": false,
						"icon": "http://media.breadtrip.com/images/icons/2/country.png",
						"type": 1,
						"id": "TH",
						"has_route_maps": false,
						"rating_users": 0
					},
					{
						"rating": 0,
						"name": "芬兰",
						"url": "/scenic/1/3613/",
						"wish_to_go_count": 665,
						"name_orig": "芬兰",
						"visited_count": 1058,
						"comments_count": 0,
						"location": {
							"lat": 61.92411,
							"lng": 25.748151
						},
						"has_experience": false,
						"icon": "http://media.breadtrip.com/images/icons/2/country.png",
						"type": 1,
						"id": "FI",
						"has_route_maps": false,
						"rating_users": 0
					},
					{
						"rating": 0,
						"name": "美国",
						"url": "/scenic/1/3803/",
						"wish_to_go_count": 8828,
						"name_orig": "美国",
						"visited_count": 12967,
						"comments_count": 0,
						"location": {
							"lat": 37.09024,
							"lng": -95.712891
						},
						"has_experience": false,
						"icon": "http://media.breadtrip.com/images/icons/2/country.png",
						"type": 1,
						"id": "US",
						"has_route_maps": false,
						"rating_users": 0
					},
					{
						"rating": 0,
						"name": "马来西亚",
						"url": "/scenic/1/3676/",
						"wish_to_go_count": 6339,
						"name_orig": "马来西亚",
						"visited_count": 9533,
						"comments_count": 0,
						"location": {
							"lat": 4.210484,
							"lng": 101.975766
						},
						"has_experience": false,
						"icon": "http://media.breadtrip.com/images/icons/2/country.png",
						"type": 1,
						"id": "MY",
						"has_route_maps": false,
						"rating_users": 0
					},
					{
						"rating": 0,
						"name": "意大利",
						"url": "/scenic/1/3720/",
						"wish_to_go_count": 7689,
						"name_orig": "意大利",
						"visited_count": 6508,
						"comments_count": 0,
						"location": {
							"lat": 41.87194,
							"lng": 12.56738
						},
						"has_experience": false,
						"icon": "http://media.breadtrip.com/images/icons/2/country.png",
						"type": 1,
						"id": "IT",
						"has_route_maps": false,
						"rating_users": 0
					},
					{
						"rating": 0,
						"name": "新加坡",
						"url": "/scenic/1/3589/",
						"wish_to_go_count": 5847,
						"name_orig": "新加坡",
						"visited_count": 7835,
						"comments_count": 0,
						"location": {
							"lat": 1.352083,
							"lng": 103.819836
						},
						"has_experience": false,
						"icon": "http://media.breadtrip.com/images/icons/2/country.png",
						"type": 1,
						"id": "SG",
						"has_route_maps": false,
						"rating_users": 0
					},
					{
						"rating": 0,
						"name": "挪威",
						"url": "/scenic/1/3258/",
						"wish_to_go_count": 788,
						"name_orig": "挪威",
						"visited_count": 850,
						"comments_count": 0,
						"location": {
							"lat": 60.472024,
							"lng": 8.468946
						},
						"has_experience": false,
						"icon": "http://media.breadtrip.com/images/icons/2/country.png",
						"type": 1,
						"id": "NO",
						"has_route_maps": false,
						"rating_users": 0
					}
				],
				"type": "destination",
				"title": "国外热门目的地"
			},
			{
				"elements": [
					{
						"rating": 0,
						"name": "台湾",
						"url": "/scenic/1/3660/",
						"wish_to_go_count": 37947,
						"name_orig": "台湾",
						"visited_count": 15729,
						"comments_count": 0,
						"location": {
							"lat": 23.69781,
							"lng": 120.960515
						},
						"has_experience": false,
						"icon": "http://media.breadtrip.com/images/icons/2/country.png",
						"type": 1,
						"id": "TW",
						"has_route_maps": false,
						"rating_users": 0
					},
					{
						"rating": 0,
						"name": "香港",
						"url": "/scenic/1/3814/",
						"wish_to_go_count": 23495,
						"name_orig": "香港",
						"visited_count": 31249,
						"comments_count": 0,
						"location": {
							"lat": 22.396428,
							"lng": 114.109497
						},
						"has_experience": false,
						"icon": "http://media.breadtrip.com/images/icons/2/country.png",
						"type": 1,
						"id": "HK",
						"has_route_maps": true,
						"rating_users": 0
					},
					{
						"rating": 0,
						"name": "厦门",
						"url": "/scenic/3/65012/",
						"wish_to_go_count": 29887,
						"name_orig": "厦门",
						"visited_count": 26077,
						"comments_count": 0,
						"location": {
							"lat": 24.477188,
							"lng": 118.094398
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "厦门",
						"name_en": "Xiamen",
						"type": 3,
						"id": 65012,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					},
					{
						"rating": 0,
						"name": "北京",
						"url": "/scenic/3/8248/",
						"wish_to_go_count": 7118,
						"name_orig": "北京",
						"visited_count": 53416,
						"comments_count": 0,
						"location": {
							"lat": 39.90561,
							"lng": 116.413634
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "北京",
						"name_en": "Beijing",
						"type": 3,
						"id": 8248,
						"has_route_maps": true,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					},
					{
						"rating": 0,
						"name": "丽江市",
						"url": "/scenic/3/65362/",
						"wish_to_go_count": 27368,
						"name_orig": "丽江市",
						"visited_count": 19389,
						"comments_count": 0,
						"location": {
							"lat": 26.851553,
							"lng": 100.228931
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "丽江市",
						"name_en": "Lijiang",
						"type": 3,
						"id": 65362,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					},
					{
						"rating": 0,
						"name": "成都",
						"url": "/scenic/3/14209/",
						"wish_to_go_count": 14464,
						"name_orig": "成都",
						"visited_count": 23484,
						"comments_count": 0,
						"location": {
							"lat": 30.569858,
							"lng": 104.069084
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "成都",
						"name_en": "Chengdu",
						"type": 3,
						"id": 14209,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					},
					{
						"rating": 0,
						"name": "上海",
						"url": "/scenic/3/13961/",
						"wish_to_go_count": 7601,
						"name_orig": "上海",
						"visited_count": 46500,
						"comments_count": 0,
						"location": {
							"lat": 31.228402,
							"lng": 121.478143
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "上海",
						"name_en": "Shanghai",
						"type": 3,
						"id": 13961,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					},
					{
						"rating": 0,
						"name": "拉萨",
						"url": "/scenic/3/5249/",
						"wish_to_go_count": 15492,
						"name_orig": "拉萨",
						"visited_count": 6544,
						"comments_count": 0,
						"location": {
							"lat": 29.649671,
							"lng": 91.173526
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "拉萨",
						"name_en": "Lhasa",
						"type": 3,
						"id": 5249,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					},
					{
						"rating": 0,
						"name": "大理",
						"url": "/scenic/3/43908/",
						"wish_to_go_count": 10103,
						"name_orig": "大理",
						"visited_count": 13291,
						"comments_count": 0,
						"location": {
							"lat": 25.603496,
							"lng": 100.268781
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "大理",
						"name_en": "Dali",
						"type": 3,
						"id": 43908,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					},
					{
						"rating": 0,
						"name": "三亚",
						"url": "/scenic/3/65557/",
						"wish_to_go_count": 8951,
						"name_orig": "三亚",
						"visited_count": 11920,
						"comments_count": 0,
						"location": {
							"lat": 18.251176,
							"lng": 109.51604
						},
						"has_experience": false,
						"rating_users": 0,
						"name_zh": "三亚",
						"name_en": "Sanya",
						"type": 3,
						"id": 65557,
						"has_route_maps": false,
						"icon": "http://media.breadtrip.com/images/icons/2/city.png"
					}
				],
				"type": "destination",
				"title": "国内热门目的地"
			}
		],
		"date_time": "2017-09-11 10:52:27.811321",
		"elements": [
			{
				"type": 1,
				"data": [
					[
						{
							"platform": "android",
							"image_url": "http://photos.breadtrip.com/covers_2017_09_05_d5b225291045767fcfa0508f3d96ae26.jpg?imageView/2/w/960/",
							"html_url": "http://www.iqiyi.com/v_19rr8w7drg.html?dummy=&wx_uid2=wxidoG0a9jsIGfq1jln1HtWebMCOKKSQ"
						},
						{
							"platform": "android",
							"image_url": "http://photos.breadtrip.com/covers_2014_12_25_ed43331bac65ee0752f7e56116993b2c.jpg?imageView2/2/w/750/format/jpg/interlace/1/",
							"html_url": "http://web.breadtrip.com/mobile/destination/topic/2387718817/"
						},
						{
							"platform": "android",
							"image_url": "http://photos.breadtrip.com/covers_2014_10_29_46217a91ace672787ed1fec4c2011b52.png?imageView2/2/w/750/format/jpg/interlace/1/",
							"html_url": "http://web.breadtrip.com/mobile/destination/topic/2387718790/"
						},
						{
							"platform": "android",
							"image_url": "http://photos.breadtrip.com/covers_2015_04_24_59b10571419fb3888224d83365f561e8.jpg?imageView2/2/w/750/format/jpg/interlace/1/",
							"html_url": "http://web.breadtrip.com/mobile/destination/topic/2387718734/"
						},
						{
							"platform": "android",
							"image_url": "http://photos.breadtrip.com/covers_2014_12_05_c9aea564f43b673ea6d8dcf9c6c4627b.jpg?imageView2/2/w/750/format/jpg/interlace/1/",
							"html_url": "http://web.breadtrip.com/mobile/destination/topic/2387718810/"
						},
						{
							"platform": "android",
							"image_url": "http://photos.breadtrip.com/covers_2016_02_26_51987e2bebba67bad75ccb114dfea7ab.png?imageView2/2/w/750/format/jpg/interlace/1/",
							"html_url": "http://web.breadtrip.com/mobile/destination/topic/2387719110/"
						}
					]
				],
				"desc": "广告banner"
			},
			{
				"type": 11,
				"data": [
					{
						"title": "每日精选故事"
					}
				],
				"desc": ""
			},
			{
				"type": 10,
				"data": [
					{
						"text": "halo 雷猴嘛\n我猜你是个妹纸\n我猜你是个爱美的妹纸\n我猜你是个喜欢首饰and爱美的妹纸\n我猜你是个喜欢手作首饰and爱美的妹纸\n我猜…你是个亲手做首饰给女票的汉纸!\n\n\n\n我是个喜欢手工喜欢首饰喜欢发现美的美男纸，来吃我一安利呗!",
						"is_liked": false,
						"index_cover": "http://photos.breadtrip.com/photo_d_2016_08_02_dca0659576dfe60382943612e2fff308ff2b1f1d56055e6b29f6fdd317f3ff8c.jpeg?imageView/2/w/960/q/85",
						"poi": {},
						"cover_image_height": 1206,
						"trip_id": 2387270842,
						"index_title": "",
						"center_point": {
							"lat": 0,
							"lng": 0
						},
						"view_count": 45446,
						"location_alias": "Dream High梦想社",
						"cover_image_1600": "http://photos.breadtrip.com/photo_d_2016_08_02_09931d012facf6186f9c25202983dcaa68efddaccb4cbc0e78a0ded46afb778e.jpeg?imageView/2/w/1384/h/1384/q/85",
						"cover_image_s": "http://photos.breadtrip.com/photo_d_2016_08_02_09931d012facf6186f9c25202983dcaa68efddaccb4cbc0e78a0ded46afb778e.jpeg?imageView/1/w/280/h/280/q/75",
						"share_url": "btrip/spot/2387867495/",
						"timezone": "Asia/Shanghai",
						"date_tour": "2016-07-31T20:49:00+08:00",
						"is_hiding_location": true,
						"user": {
							"location_name": "广东_广州",
							"name": "林酷儿",
							"resident_city_id": 275,
							"mobile": "",
							"gender": 2,
							"avatar_m": "http://photos.breadtrip.com/avatar_17_c1_1214298920959e94700b4cb370271320c5745e6c.jpg-avatar.m",
							"cover": "http://photos.breadtrip.com/default_user_cover_06.jpg-usercover.display",
							"custom_url": "",
							"experience": {
								"value": 101,
								"level_info": {
									"name": "",
									"value": 2
								}
							},
							"id": 2384430044,
							"birthday": "",
							"country_num": null,
							"avatar_s": "http://photos.breadtrip.com/avatar_17_c1_1214298920959e94700b4cb370271320c5745e6c.jpg-avatar.s",
							"country_code": null,
							"email_verified": false,
							"is_hunter": false,
							"cdc2": false,
							"avatar_l": "http://photos.breadtrip.com/avatar_17_c1_1214298920959e94700b4cb370271320c5745e6c.jpg-avatar.l",
							"email": "",
							"user_desc": "",
							"points": 26
						},
						"spot_id": 2387867495,
						"is_author": false,
						"cover_image_w640": "http://photos.breadtrip.com/photo_d_2016_08_02_09931d012facf6186f9c25202983dcaa68efddaccb4cbc0e78a0ded46afb778e.jpeg?imageView/1/w/640/h/480/q/85",
						"region": {
							"primary": "",
							"secondary": ""
						},
						"comments_count": 9,
						"cover_image": "http://photos.breadtrip.com/photo_d_2016_08_02_09931d012facf6186f9c25202983dcaa68efddaccb4cbc0e78a0ded46afb778e.jpeg?imageView/2/w/960/q/85",
						"cover_image_width": 1600,
						"recommendations_count": 22
					}
				],
				"desc": ""
			},
			{
				"type": 10,
				"data": [
					{
						"text": "挑战极限和心跳，让自己成为一个有趣的人。\n2016月5月在面包旅行，偶然下兼职做一个猎人哈哈（活动名字上帝之眼），感觉挺酷的。\n重庆最具特色的，当然是城市里最耀眼的高楼夜景，曾经有一部电影“重庆森林”，故事很多场景，以及城市展现出重庆这座奇葩一样的城市，独具特色话3D话，很多电影都有在重庆取景。",
						"is_liked": false,
						"index_cover": "http://photos.breadtrip.com/photo_d_2016_06_24_4bc9f811fa5b900762fb1d55dff164f32066a28d4010bf9f4a4c20dd62634b4d.jpg?imageView/2/w/960/q/85",
						"poi": {
							"tel": "023-62872299",
							"currency": "CNY",
							"is_nearby": true,
							"timezone": "Asia/Chongqing",
							"id": 2387458620,
							"category": 11,
							"recommended_reason": "看滚滚江水向东流去，犹如有登高望远",
							"fee": "免费",
							"spot_region": "重庆",
							"date_added": "2014-12-16 10:48:55",
							"time_consuming_max": 0,
							"time_consuming": null,
							"extra1": "",
							"recommended": true,
							"location": {
								"lat": 29.554926,
								"lng": 106.586696
							},
							"opening_time": "全天",
							"type": 5,
							"time_consuming_min": 0,
							"website": "",
							"description": "长江索道起于渝中区长安寺，横跨长江至南岸区上新街。乘坐过江索道，除了可以欣赏两江美景外，还可以从索道上俯瞰洪崖洞、湖广会馆、南滨路等著名景观。",
							"arrival_type": "乘105、132、135、153、181、261、0321夜班、476、0491夜班、0492夜班、0493夜班、871、898路等公交车在新华路站下车即到",
							"address": "重庆市渝中区新华路153号",
							"verified": true,
							"name_en": "",
							"icon": "http://media.breadtrip.com/images/icons/poi_category_11.png",
							"name": "长江索道",
							"popularity": 809
						},
						"cover_image_height": 1067,
						"trip_id": 2387276098,
						"index_title": "",
						"center_point": {
							"lat": 0,
							"lng": 0
						},
						"view_count": 49744,
						"location_alias": "",
						"cover_image_1600": "http://photos.breadtrip.com/photo_d_2016_06_24_7df54edb43492917e7d1cb743a4a379b92bc85c2562bb6b1a39d346c4f6fc0e9.jpg?imageView/2/w/1384/h/1384/q/85",
						"cover_image_s": "http://photos.breadtrip.com/photo_d_2016_06_24_7df54edb43492917e7d1cb743a4a379b92bc85c2562bb6b1a39d346c4f6fc0e9.jpg?imageView/1/w/280/h/280/q/75",
						"share_url": "btrip/spot/2387843168/",
						"timezone": "Asia/Shanghai",
						"date_tour": "2016-06-24T10:51:14+08:00",
						"is_hiding_location": false,
						"user": {
							"location_name": "",
							"name": "W猫小北",
							"resident_city_id": 288652,
							"mobile": "",
							"gender": 1,
							"avatar_m": "http://photos.breadtrip.com/avatar_bc_fd_a6720f5e50d1f22194c51f73329f0e9c48ab7ba8.jpg-avatar.m",
							"cover": "http://photos.breadtrip.com/default_user_cover_05.jpg-usercover.display",
							"custom_url": "",
							"experience": {
								"value": 1242,
								"level_info": {
									"name": "",
									"value": 4
								}
							},
							"id": 2387577484,
							"birthday": "",
							"country_num": "86",
							"avatar_s": "http://photos.breadtrip.com/avatar_bc_fd_a6720f5e50d1f22194c51f73329f0e9c48ab7ba8.jpg-avatar.s",
							"country_code": "CN",
							"email_verified": false,
							"is_hunter": true,
							"cdc2": false,
							"avatar_l": "http://photos.breadtrip.com/avatar_bc_fd_a6720f5e50d1f22194c51f73329f0e9c48ab7ba8.jpg-avatar.l",
							"email": "",
							"user_desc": "我是猫小北，喜欢摄影摄像以及美食旅行，独自旅行大半中国，特长就是长得帅，吃得多还不胖。喜欢用心记录不容易发现的美好，我想记录这一切的美好。",
							"points": 87
						},
						"spot_id": 2387843168,
						"is_author": false,
						"cover_image_w640": "http://photos.breadtrip.com/photo_d_2016_06_24_7df54edb43492917e7d1cb743a4a379b92bc85c2562bb6b1a39d346c4f6fc0e9.jpg?imageView/1/w/640/h/480/q/85",
						"region": {
							"primary": "",
							"secondary": ""
						},
						"comments_count": 7,
						"cover_image": "http://photos.breadtrip.com/photo_d_2016_06_24_7df54edb43492917e7d1cb743a4a379b92bc85c2562bb6b1a39d346c4f6fc0e9.jpg?imageView/2/w/960/q/85",
						"cover_image_width": 1600,
						"recommendations_count": 40
					}
				],
				"desc": ""
			},
			{
				"type": 10,
				"data": [
					{
						"text": "很有幸能有王老这样的人让我们能睹旧物思旧人旧事，陈列室虽不大，却也充斥了老北京饮食医用居的方方面面，可以亲手触摸历史，了解自己现在工作城市的过去现在让人倍感亲切！",
						"is_liked": false,
						"index_cover": "http://photos.breadtrip.com/photo_d_2016_06_09_23_56_51_174_123986672_-1220261189.jpg?imageView/2/w/960/q/85",
						"poi": "",
						"cover_image_height": 724,
						"trip_id": 2387247307,
						"index_title": "",
						"center_point": {},
						"view_count": 39166,
						"location_alias": "",
						"cover_image_1600": "http://photos.breadtrip.com/photo_d_2016_06_09_23_56_50_703_123986672_834948024.jpg?imageView/2/w/1384/h/1384/q/85",
						"cover_image_s": "http://photos.breadtrip.com/photo_d_2016_06_09_23_56_50_703_123986672_834948024.jpg?imageView/1/w/280/h/280/q/75",
						"share_url": "btrip/spot/2387849028/",
						"timezone": "Asia/Shanghai",
						"date_tour": "2016-06-09T23:42:30+08:00",
						"is_hiding_location": false,
						"user": {
							"location_name": "",
							"name": "Lucy鱼er",
							"resident_city_id": "",
							"mobile": "",
							"gender": 2,
							"avatar_m": "http://photos.breadtrip.com/avatar_d0_f2_9450f59011820dcdfe7f0317d76f7fb0654cf52c.jpg-avatar.m",
							"cover": "http://media.breadtrip.com/user_covers/default/cover_3.jpg",
							"custom_url": "",
							"experience": {
								"value": 132,
								"level_info": {
									"name": "",
									"value": 2
								}
							},
							"id": 2386840189,
							"birthday": "",
							"country_num": null,
							"avatar_s": "http://photos.breadtrip.com/avatar_d0_f2_9450f59011820dcdfe7f0317d76f7fb0654cf52c.jpg-avatar.s",
							"country_code": null,
							"email_verified": false,
							"is_hunter": false,
							"cdc2": false,
							"avatar_l": "http://photos.breadtrip.com/avatar_d0_f2_9450f59011820dcdfe7f0317d76f7fb0654cf52c.jpg-avatar.l",
							"email": "",
							"user_desc": "",
							"points": 52
						},
						"spot_id": 2387849028,
						"is_author": false,
						"cover_image_w640": "http://photos.breadtrip.com/photo_d_2016_06_09_23_56_50_703_123986672_834948024.jpg?imageView/1/w/640/h/480/q/85",
						"region": {
							"primary": "",
							"secondary": ""
						},
						"comments_count": 2,
						"cover_image": "http://photos.breadtrip.com/photo_d_2016_06_09_23_56_50_703_123986672_834948024.jpg?imageView/2/w/960/q/85",
						"cover_image_width": 965,
						"recommendations_count": 13
					}
				],
				"desc": ""
			},
			{
				"type": 10,
				"data": [
					{
						"text": "献给爱我们的女神",
						"is_liked": false,
						"index_cover": "http://photos.breadtrip.com/photo_d_2016_06_19_01_21_20_989_123986672_17737936936133063098.jpg?imageView/2/w/960/q/85",
						"poi": "",
						"cover_image_height": 816,
						"trip_id": 2387282916,
						"index_title": "",
						"center_point": {},
						"view_count": 36207,
						"location_alias": "",
						"cover_image_1600": "http://photos.breadtrip.com/photo_d_2016_06_19_01_21_20_926_123986672_17737936923172662193.jpg?imageView/2/w/1384/h/1384/q/85",
						"cover_image_s": "http://photos.breadtrip.com/photo_d_2016_06_19_01_21_20_926_123986672_17737936923172662193.jpg?imageView/1/w/280/h/280/q/75",
						"share_url": "btrip/spot/2387842143/",
						"timezone": "Asia/Shanghai",
						"date_tour": "2016-06-19T01:19:07+08:00",
						"is_hiding_location": false,
						"user": {
							"location_name": "",
							"name": "丑到没墙角",
							"resident_city_id": "",
							"mobile": "",
							"gender": 2,
							"avatar_m": "http://photos.breadtrip.com/avatar_41_b8_aedfd71640e3ec09d0c30edc47df04dc56dbf38a.jpg-avatar.m",
							"cover": "http://photos.breadtrip.com/default_user_cover_10.jpg-usercover.display",
							"custom_url": "",
							"experience": {
								"value": 59,
								"level_info": {
									"name": "",
									"value": 1
								}
							},
							"id": 2384288641,
							"birthday": "",
							"country_num": null,
							"avatar_s": "http://photos.breadtrip.com/avatar_41_b8_aedfd71640e3ec09d0c30edc47df04dc56dbf38a.jpg-avatar.s",
							"country_code": null,
							"email_verified": false,
							"is_hunter": false,
							"cdc2": false,
							"avatar_l": "http://photos.breadtrip.com/avatar_41_b8_aedfd71640e3ec09d0c30edc47df04dc56dbf38a.jpg-avatar.l",
							"email": "",
							"user_desc": "",
							"points": 2
						},
						"spot_id": 2387842143,
						"is_author": false,
						"cover_image_w640": "http://photos.breadtrip.com/photo_d_2016_06_19_01_21_20_926_123986672_17737936923172662193.jpg?imageView/1/w/640/h/480/q/85",
						"region": {
							"primary": "",
							"secondary": ""
						},
						"comments_count": 2,
						"cover_image": "http://photos.breadtrip.com/photo_d_2016_06_19_01_21_20_926_123986672_17737936923172662193.jpg?imageView/2/w/960/q/85",
						"cover_image_width": 1088,
						"recommendations_count": 21
					}
				],
				"desc": ""
			},
			{
				"type": 9,
				"data": [
					{
						"title": "精彩原创和专题"
					}
				],
				"desc": ""
			}
		]
	}
}
yelinlan
关注
  • 2
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Python实现读取json文件到excel表
09-21
主要介绍了Python实现读取json文件到excel表，具有一定的参考价值，感兴趣的小伙伴们可以参考一下
excel转json工具
09-03
拖拽excel至该脚本工具，可输出为json文件 excel内前两行为字段名
将json文件转化为excel文件
m0_56986233的博客
10-10 3107
json文件转化为excel文件
json转excel
最新发布
dgiij的博客
05-03 585
前面有介绍过excel文件转换成json文件的方法，那json文件转excel文件呢？如果json文件里数据格式都是统一的话，那么也比较容易就转。在项目文件夹下有待转换json文件，转出的xlsx文件也存放在此，这样就可以执行以下命令转换json文件到excel文件了。
Java实战：JSON文件到Excel文件的转换
心猿意码
04-22 817
库来创建Excel文件，并将Java对象的数据填充到Excel中。库来解析JSON文件，并将其转换为Java对象。如果你使用的是Maven，可以在。首先，确保你的项目中已经添加了。类，以及一个包含多个。对象的JSON文件。
json 转为excel 工具
lvjing41866的博客
11-01 385
请先正常打开一份空白的excel文件，将鼠标定位在第一行第一列，这边鼠标定位的位置将决定后续打开的csv文件在excel中展示的位置，如下图所示。点击“下一步”就可以预览效果了，如下图1所示，这时候再点击“完成”页面就跳转到如下图2所示的对话框，提示导入的数据的放置位置。在导入位置中可以选择指定的单元格，也可以选择“新建工作表”进行数据的导入，设置好之后，点击“确定”就完成了csv文件的打开了。在excel的上方菜单中点击数据，如上个步骤截图中标红的数据，页面切换后，点击下图中标红的“自文本”。
Json转excel
WHY DUET的博客
08-08 7365
python3 实现json数据转excel
JS 读取excel文件内容 和 将json数据导出excel文件
weixin_44646763的博客
11-16 2080
JS 读取excel文件内容 和 将json数据导出excel文件
JSON数据转换成Excel
阿福聊编程
02-23 242
工具使用
json文件转Excel文件
LYD666888999的博客
02-13 427
【代码】json文件转Excel文件。3G大小的json文件转Excel文件成功
如何把json转换成excel,json和excel相互转换不受大小限制
qishinihenhao的专栏
11-30 368
最近在工作中遇到一个测试问题，把excel数据转json在服务端做数据清洗，因为有些数据不对需要用程序判断， ，然后清洗的数据需要再转到json数据，用到了两个在线的工具， excel转json工具： http://www.yzcopen.com/doc/exceljson 一共会转出三种格式的json， 然后json数据转到excel： http://www.yzcopen.com/doc/jsonexcel 支持其中一种json格式转到excel 多亏这两工具很快解决了我的工作问题，推荐给大家 ..
Json文件一键转Excel
12-26
C# 实现批量一键把Json文佳转化问exce文件，附带源码，简单实用。
excel和json相互转换
07-09
自己写的工具，可以很方便的使用excel和json进行相互转换，生成在同级目录
JSON对象转成Excel导出
02-01
JSON对象转成Excel导出。例子： var option = {}; option.fileName = '多行业导出' option.datas=[ { sheetData:sd1, sheetName:'用电情况', //sheetFilter:['two','one'], sheetHeader:sh1 }, { sheetData:sd3, sheetName:'增速趋势', sheetHeader:sh3 } ]; var toExcel=new ExportJsonExcel(option); toExcel.saveExcel();
excel导出为json
04-25
分为数组导出,和键值对导出, 可设置头部长度(用于写备注等), 可设置导出小写, 选择需要的导出编码格式, Save JSON可直接导出, 亦可复制json另行使用
excel文件转json文件
09-16
安装node.js后（最好是8.0以下的版本）后安装gulp，然后运行star.bat文件，不要关闭窗口，要配置的excel放入config种，会在build生产对应的json文件
基于python实现把json数据转换成Excel表格
12-20
json数据： [{“authenticate”:-99,”last_ip”:”156.2.98.429″,”last_time”:”2020/05/23 01:41:36″,”member_id”:5067002,”mg_id”:1,”name”:”yuanfang”,”status”:0,”username”:”L7898″},{...
ExcelToJson.7z
04-19
写了一个简单的Excel转json工具，将一个Excel中的所有sheet转为json，存储在一个json文件中， 支持后缀名为 .xlsx .xls .xlsm,其他的没试过不知道行不行。
json数据转成excel / excel转json
wuzj1314的博客
05-11 1139
从数据库导出的数据是json格式，需要做出excel给客户。点击应用商店，搜索json to excel。工作中遇到客户要导出数据。在此输入json数据。
python将json文件转为excel
07-28
要将JSON文件转换为Excel文件，可以使用Python中的pandas库。以下是一个示例代码： ```python import json import pandas as pd # 读取JSON文件 with open("data.json", 'r', encoding='utf-8') as f: json_data = json.load(f) # 将JSON数据转换为列表形式 data_list = \[\] for json_dict in json_data: row_list = \[\] for key, value in json_dict.items(): row_list.append(value) data_list.append(row_list) # 创建DataFrame对象 df = pd.DataFrame(data_list) # 将DataFrame对象写入Excel文件 df.to_excel('data.xlsx', sheet_name='Sheet1', index=False, header=None) ``` 这段代码首先使用`json.load()`函数读取JSON文件的内容，并将其转换为Python的列表形式。然后，使用pandas库的DataFrame对象将列表转换为表格数据。最后，使用`to_excel()`函数将DataFrame对象写入Excel文件中。请确保在运行代码之前已经安装了pandas库。 #### 引用[.reference_title] - *1* *2* [在python中将json文件转化为excel文件](https://blog.csdn.net/shiyuhaohaoa/article/details/119493769)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] - *3* [python中() [] {}的区别](https://blog.csdn.net/weixin_44748127/article/details/127246522)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值