Python进阶教程：自动化办公实战

1
import openpyxl
2

3
# 打开工作簿
4
wb = openpyxl.load_workbook("sales.xlsx")
5
ws = wb.active
6

7
# 读取单元格
8
print(ws["A1"].value)
9
print(ws.cell(row=2, column=1).value)
10

11
# 遍历所有行
12
for row in ws.iter_rows(min_row=1, values_only=True):
13
    print(row)
14

15
# 获取行列数
16
print(ws.max_row, ws.max_column)

1
import openpyxl
2

3
wb = openpyxl.Workbook()
4
ws = wb.active
5
ws.title = "成绩表"
6

7
# 写入表头
8
headers = ["姓名", "语文", "数学", "英语"]
9
ws.append(headers)
10

11
# 写入数据
12
students = [
13
    ("张三", 90, 85, 92),
14
    ("李四", 78, 95, 88),
15
    ("王五", 85, 90, 86),
16
]
17
for stu in students:
18
    ws.append(stu)
19

20
from openpyxl.styles import Font
21
ws["A1"].font = Font(bold=True)
22
ws.column_dimensions["A"].width = 12
23

24
wb.save("output.xlsx")
25
print("保存成功")

1
import openpyxl
2
import glob
3

4
def merge_excels(pattern, output):
5
    """合并多个 Excel 文件"""
6
    wb_out = openpyxl.Workbook()
7
    ws_out = wb_out.active
8

9
    for file in glob.glob(pattern):
10
        wb = openpyxl.load_workbook(file)
11
        ws = wb.active
12
        print(f"处理：{file}")
13
        for row in ws.iter_rows(values_only=True):
14
            ws_out.append(row)
15

16
    wb_out.save(output)
17
    print(f"已合并到 {output}")
18

19
# merge_excels("data/*.xlsx", "merged.xlsx")

1
from docx import Document
2

3
# 创建文档
4
doc = Document()
5
doc.add_heading("工作报告", level=1)
6
doc.add_paragraph("这是第一段内容。")
7
doc.add_paragraph("这是第二段内容。")
8

9
# 添加表格
10
table = doc.add_table(rows=3, cols=2)
11
table.cell(0, 0).text = "项目"
12
table.cell(0, 1).text = "进度"
13
table.cell(1, 0).text = "开发"
14
table.cell(1, 1).text = "80%"
15

16
doc.save("report.docx")
17

18
# 读取文档
19
doc2 = Document("report.docx")
20
for para in doc2.paragraphs:
21
    print(para.text)

1
import pdfplumber
2

3
with pdfplumber.open("document.pdf") as pdf:
4
    print(f"共 {len(pdf.pages)} 页")
5
    text = pdf.pages[0].extract_text()
6
    print(text[:200])
7

8
    table = pdf.pages[0].extract_table()
9
    if table:
10
        for row in table:
11
            print(row)

1
from pathlib import Path
2
import shutil
3

4
src = Path("downloads")
5
dst = Path("organized")
6

7
for file in src.iterdir():
8
    if file.is_file():
9
        ext = file.suffix.lstrip(".") or "other"
10
        target_dir = dst / ext
11
        target_dir.mkdir(parents=True, exist_ok=True)
12
        shutil.move(str(file), str(target_dir / file.name))
13
        print(f"移动 {file.name} -> {ext}/" )

1
import openpyxl
2
from docx import Document
3

4
def generate_report(excel_file, output_docx):
5
    """从 Excel 读取成绩，生成 Word 报告"""
6
    wb = openpyxl.load_workbook(excel_file)
7
    ws = wb.active
8

9
    doc = Document()
10
    doc.add_heading("学生成绩报告", level=1)
11

12
    total = 0
13
    count = 0
14
    for row in ws.iter_rows(min_row=2, values_only=True):
15
        name, chinese, math, english = row
16
        avg = (chinese + math + english) / 3
17
        total += avg
18
        count += 1
19
        doc.add_paragraph(f"{name}：平均分 {avg:.1f}")
20

21
    if count:
22
        doc.add_paragraph(f"全班平均分：{total/count:.1f}")
23

24
    doc.save(output_docx)
25
    print(f"报告已生成：{output_docx}")
26

27
# generate_report("scores.xlsx", "report.docx")