Python实现读取redis数据并导出至excel

最新推荐文章于 2024-08-08 14:26:39 发布

原创最新推荐文章于 2024-08-08 14:26:39 发布 · 1.5k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#python #redis #excel

Python 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了如何使用Python连接到Redis数据库，读取存储的数据，并将其转换为Excel格式进行导出，适合需要将NoSQL数据整理成表格文件的场景。

import redis
import json
import os
import sys
import xlsxwriter
class connectRedis():
	def __init__(self):
		self.host = 'hosthosthost'
		self.port = '6379'
		self.auth = '密码密码'
		self.r = redis.Redis(host=self.host, port=self.port, password=self.auth,decode_responses=True)
	def existskey(self,keyname):
		return self.r.exists(keyname)
	def getvalue(self):
		valuelist = []
		Keys = connectRedis().r.keys()
		for i in Keys:
			if '需要找的key' in str(i):
				value = json.loads(eval(connectRedis().r.get(i)))
				valuelist.append([value['值1'],value['值2']])
		return valuelist
def write_excel_xlsx(value):
    rootpath = os.getcwd()
    path = os.path.join(rootpath,'预订单号.xlsx')
    newxlsx = xlsxwriter.Workbook(path)
    newsheet = newxlsx.add_worksheet()
    for i in range(0,len(value)):
        for j in range(len(value[1])):
            newsheet.write(i-1,j,str(value[i][j]))
    newxlsx.close()
    print("xlsx格式表格写入数据成功！")
write_excel_xlsx(connectRedis().getvalue())