import redis
import pandas as pd
# 连接到Redis
redis_host = 'redis数据库服务器ip'
redis_port = 6379
r = redis.Redis(host=redis_host, port=6379, decode_responses=True, password='redis数据库密码')
# 获取所有的键
keys = r.keys()
# 使用Pandas创建一个DataFrame
data = {key: r.get(key) for key in keys}
df = pd.DataFrame.from_dict(data, orient='index')
df.columns = ['Value']
df.reset_index(inplace=True)
df.columns = ['Key', 'Value']
# 导出到Excel
df.to_excel('redis_export.xlsx', index=False)
12-14