在实际项目应用中,会出现ppt折线图的情况,部分代码示例。
代码如下:
from pptx import Presentation
from pptx.enum.text import PP_PARAGRAPH_ALIGNMENT
from pptx.chart.data import ChartData
from pptx.util import Pt
def ppt(prs,template_path):
# 走势图
dir=os.getcwd()
#prs = Presentation(template_path)
#print([slide.slide_id for slide in prs.slides])
wb = xlrd.open_workbook(dir+r'\\数据源\\价格走势(3).xlsx')
ws = wb.sheet_by_name('Table')
slide = prs.slides.get(1633)
cht = [tb.chart for tb in slide.shapes if tb.has_chart][0]
date, data1, data2 = ws.col_values(5)[16:], ws.col_values(6)[16:], ws.col_values(7)[16:]
data_yy,data_japan=[],[]
m=0
for i in range(0,len(data1)):
if data1[i] is None or data1[i]=='':
while data1[i] is None or data2[i]=