from clickhouse_driver import Client
import pandas as pd
def export_excel():
#链接clickhouse获取数据转换成DataFrame
click_client = Client("192.168.1.123", "9000", "test", "user", "passwd")
sql = 'select appid,time from test limit 5'
all_data = click_client.execute(sql)
print(all_data)
dataf = pd.DataFrame(all_data)
print(dataf)
# 创建excel
writer = pd.ExcelWriter("test.xlsx")
dataf.to_excel(writer, sheet_name='Data1',index=False)
writer.save()
if __name__=='__main__':
export_excel()