一站式网上办事大厅

import requests

from bs4 import BeautifulSoup

# 登录信息

login_url = 'https://example.com/login'

payload = {

'username': 'your_username',

'password': 'your_password'

}

session = requests.Session()

response = session.post(login_url, data=payload)

# 获取数据页面

grades_url = 'https://example.com/grades'

grades_response = session.get(grades_url)

soup = BeautifulSoup(grades_response.text, 'html.parser')

# 解析数据

grades = []

for row in soup.find_all('tr'):

cols = row.find_all('td')

if len(cols) > 0:

grades.append([col.text.strip() for col in cols])

print(grades)

from pptx import Presentation

from pptx.util import Inches

# 创建PPT

prs = Presentation()

# 添加封面页

slide = prs.slides.add_slide(prs.slide_layouts[0])

title = slide.shapes.title

subtitle = slide.placeholders[1]

title.text = "我的成绩单"

subtitle.text = "生成日期：2023-10-01"

# 添加数据页

slide = prs.slides.add_slide(prs.slide_layouts[1])

table = slide.shapes.add_table(len(grades), len(grades[0]), Inches(1), Inches(1), Inches(6), Inches(4)).table

# 填充表格

for i in range(len(grades)):

for j in range(len(grades[i])):

table.cell(i, j).text = grades[i][j]

# 保存PPT

prs.save("成绩单.pptx")