python3实现json转excel

拼搏现实的明天。 2023-02-22 07:59 3阅读 0赞

## 数据 ##

[
    	{ 
    	"name":"flten",
    	"category":"com",
    	"count":1,
    	"location":"上海",
    	"time":"2020-7-2"
    	},
    	{ 
    		"name":"flten",
    		"category":"com",
    		"count":1,
    		"location":"上海",
    		"time":"2020-7-2"
    	},
    	{ 
    		"name":"flten",
    		"category":"com",
    		"count":1,
    		"location":"上海",
    		"time":"2020-7-2"
    	},
    	{ 
    		"name":"flten",
    		"category":"com",
    		"count":1,
    		"location":"上海",
    		"time":"2020-7-2"
    	},
    	{ 
    		"name":"flten",
    		"category":"com",
    		"count":1,
    		"location":"上海",
    		"time":"2020-7-2"
    	},
    	{ 
    		"name":"flten",
    		"category":"com",
    		"count":1,
    		"location":"上海",
    		"time":"2020-7-2"
    	},
    	{ 
    		"name":"flten",
    		"category":"com",
    		"count":1,
    		"location":"上海",
    		"time":"2020-7-2"
    	},
    	{ 
    		"name":"flten",
    		"category":"com",
    		"count":1,
    		"location":"上海",
    		"time":"2020-7-2"
    	}
    ]

## 代码 ##

import json
    import tablib
    
    # json.text文件的格式： [{"a":1},{"a":2},{"a":3},{"a":4},{"a":5}]
    
    # 获取ｊｓｏｎ数据
    with open('json.txt', 'r',encoding='utf-8') as f:
        rows = json.load(f)
       # print(rows)
        # 将json中的key作为header, 也可以自定义header（列名）
        header=tuple([ i for i in rows[0].keys()])
       # print('header',header)
        data = []
        # 循环里面的字典，将value作为数据写入进去
        for row in rows:
            body = []
            for v in row.values():
                body.append(v)
            data.append(tuple(body))
       # print('data',data)
        data = tablib.Dataset(*data,headers=header)
        print('data',data)
        open('data.xlsx', 'wb').write(data.xlsx)

## 过程中报错 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTI1MDMx_size_16_color_FFFFFF_t_70_pic_center]

## 原因 ##

##### 只装了`pip install tablib` ；导致安装`tablib库`不全面 #####

## 解决 ##

pip install tablib[all]

## 结果 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTI1MDMx_size_16_color_FFFFFF_t_70_pic_center 1]

## 查看生成的excel文件 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTI1MDMx_size_16_color_FFFFFF_t_70_pic_center 2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTI1MDMx_size_16_color_FFFFFF_t_70_pic_center]: https://img-blog.csdnimg.cn/20200702140419718.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTI1MDMx,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTI1MDMx_size_16_color_FFFFFF_t_70_pic_center 1]: https://img-blog.csdnimg.cn/20200702140528256.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTI1MDMx,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTI1MDMx_size_16_color_FFFFFF_t_70_pic_center 2]: https://img-blog.csdnimg.cn/20200702140649954.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTI1MDMx,size_16,color_FFFFFF,t_70#pic_center