python数据写入表格生成图片_Python中Excel表格数据生成图片

#画图

# import sys

# import os

# import io

# import datetime

# import pandas as pd

# sys.stdout = io.TextIOWrapper(sys.stdout.buffer,encoding='gb18030')

# import matplotlib.pyplot as plt

# from pandas.plotting import table

# import pandas as pd

# fig = plt.figure(figsize=(9,10),dpi=1400)

# ax = fig.add_subplot(111, frame_on=False,)

# ax.xaxis.set_visible(False) # hide the x axis

# ax.yaxis.set_visible(False) # hide the y axis

# datas = pd.read_excel('./ceshi.xlsx')

# datas = datas.iloc[:,0:]

# print(datas)

# table(ax, datas, loc='center') # where df is your data frame

# plt.savefig('./photo.jpg')