Python docx庫代碼演示
安裝
|
1
2
|
需要lxml pip install python-docx |
主業務代碼
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
|
from openpyxl import Workbookfrom openpyxl import load_workbookfrom docx import Documentfrom docx.oxml.ns import qnfrom docx.shared import Pt,RGBColor,Cmfrom docx.enum.style import WD_STYLE_TYPEimport os# 新建輸出if os.path.exists('test_out.docx'): os.remove('test_out.docx')# 讀表 i1 = load_workbook('業務節點分析20211022103647(1).xlsx')print('讀表結束')i = i1['業務節點分析']out = []# range(x,y) x到y-1行for h in range(523,528): lie = [] for l in i[h]: lie.append(l.value) out.append(lie[8])print(out)print(len(out))print('等待生成word文檔')# 創建worddoc = Document()doc.styles['Normal'].font.name = u'宋體'doc.styles['Normal'].font.size = Pt(10.5)# 設置黑體字樣式style_hei = doc.styles.add_style('hei', WD_STYLE_TYPE.CHARACTER) style_hei.font.name = '黑體'doc.styles['hei']._element.rPr.rFonts.set(qn('w:eastAsia'), u'黑體')# 設置宋體字樣式style_hei = doc.styles.add_style('song', WD_STYLE_TYPE.CHARACTER) style_hei.font.name = '宋體'doc.styles['song']._element.rPr.rFonts.set(qn('w:eastAsia'), u'宋體')# 完成進度 # 段1p1 = doc.add_paragraph() # 文字r1 = p1.add_run('完成進度',style='song')r1.font.size = Pt(22)r1.font.bold = Truep1.paragraph_format.space_before = Pt(17)p1.paragraph_format.space_after = Pt(16.5)p1.paragraph_format.line_spacing = 1.0# 表1table1 = doc.add_table(rows=len(out)+1,cols=4,style='Table Grid')table1.cell(0,0).paragraphs[0].add_run('序號',style='song')# 第二行的cell會改變原本的行寬table1.cell(0,0).width=Cm(2)table1.cell(0,1).paragraphs[0].add_run('案例名稱',style='song')table1.cell(0,2).paragraphs[0].add_run('測試狀態',style='song')table1.cell(0,3).paragraphs[0].add_run('時間',style='song')for i in range(1,len(out)+1): table1.cell(i,0).paragraphs[0].add_run(str(i),style='song') table1.cell(i,0).width=Cm(2) table1.cell(i,1).paragraphs[0].add_run(out[i-1],style='song') table1.cell(i,2).paragraphs[0].add_run('待測試/測試中/完成',style='song')'''# 產品變更 # 段2p2 = doc.add_paragraph() # 文字r2 = p2.add_run('\n一、產品變更',style='song')r2.font.size = Pt(22)r2.font.bold = Truep2.paragraph_format.space_before = Pt(17)p2.paragraph_format.space_after = Pt(16.5)p2.paragraph_format.line_spacing = 1.0'''# 前置條件+測試步驟描述for i in range(1,len(out)+1): st = str(i)+'.'+out[i-1] # 段3 p3 = doc.add_paragraph() # 文字 r3 = p3.add_run(st,style='hei') r3.font.size = Pt(16) r3.font.bold = True p3.paragraph_format.space_before = Pt(13) p3.paragraph_format.space_after = Pt(13) p3.paragraph_format.line_spacing = 1.0 # 段4 p4 = doc.add_paragraph() # 文字 r4 = p4.add_run('前置條件',style='song') r4.font.size = Pt(18) r4.font.bold = True p4.paragraph_format.line_spacing = 1.0 # 表2 table2 = doc.add_table(rows=4, cols=6,style ='Table Grid') t0 = table2.cell(0,0).paragraphs[0].add_run('號碼',style='song') t0.font.size = Pt(12) t0.font.color.rgb = RGBColor(0, 0, 255) table2.cell(0,1).merge(table2.cell(0,2)).merge(table2.cell(0,3)).merge(table2.cell(0,4)).merge(table2.cell(0,5)) t1 = table2.cell(1,0).paragraphs[0].add_run('user_ID',style='song') t1.font.size = Pt(12) t1.font.color.rgb = RGBColor(0, 0, 255) table2.cell(1,1).merge(table2.cell(1,2)).merge(table2.cell(1,3)).merge(table2.cell(1,4)).merge(table2.cell(1,5)) t2 = table2.cell(2,0).paragraphs[0].add_run('acct_ID',style='song') t2.font.size = Pt(12) t2.font.color.rgb = RGBColor(0, 0, 255) table2.cell(2,1).merge(table2.cell(2,2)).merge(table2.cell(2,3)).merge(table2.cell(2,4)).merge(table2.cell(2,5)) t3 = table2.cell(3,0).paragraphs[0].add_run('cust_ID',style='song') t3.font.size = Pt(12) t3.font.color.rgb = RGBColor(0, 0, 255) table2.cell(3,1).merge(table2.cell(3,2)).merge(table2.cell(3,3)).merge(table2.cell(3,4)).merge(table2.cell(3,5)) # 段5 p5 = doc.add_paragraph() # 文字 r5 = p5.add_run('\n測試步驟描述',style='song') r5.font.size = Pt(18) r5.font.bold = True p5.paragraph_format.line_spacing = 1.0 # 表3 table3 = doc.add_table(rows=2, cols=6,style ='Table Grid') t0 = table3.cell(0,0).paragraphs[0].add_run('Order_id',style='song') t0.font.size = Pt(12) t0.font.color.rgb = RGBColor(0, 0, 255) table3.cell(0,1).merge(table3.cell(0,2)).merge(table3.cell(0,3)).merge(table3.cell(0,4)).merge(table3.cell(0,5)) t1 = table3.cell(1,0).paragraphs[0].add_run('Trade_id',style='song') t1.font.size = Pt(12) t1.font.color.rgb = RGBColor(0, 0, 255) table3.cell(1,1).merge(table3.cell(1,2)).merge(table3.cell(1,3)).merge(table3.cell(1,4)).merge(table3.cell(1,5)) # 段6 p6 = doc.add_paragraph() # 文字 r6 = p6.add_run('\n(1)測試結果前臺截圖\n\n(2)測試結果后臺驗證\n相關TRADE表：\n相關SQL驗證：\n ①\n ②',style='song') r6.font.size = Pt(12) r6.font.color.rgb = RGBColor(0, 0, 255) p6.paragraph_format.space_after = Pt(10) p6.paragraph_format.line_spacing = 1.5# 保存doc.save('test_out.docx')print('生成test_out.docx成功') |
測試代碼（設置字體）
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
from openpyxl import Workbookfrom openpyxl import load_workbookfrom docx import Documentfrom docx.oxml.ns import qnfrom docx.shared import Pt,RGBColorfrom docx.enum.style import WD_STYLE_TYPEimport osdocument = Document() # 新建docx文檔style_song = document.styles.add_style('Song', WD_STYLE_TYPE.CHARACTER) # 設置Song字樣式style_song.font.name = '宋體'document.styles['Song']._element.rPr.rFonts.set(qn('w:eastAsia'), u'宋體') # 將段落中的所有字體style_song = document.styles.add_style('Kai', WD_STYLE_TYPE.CHARACTER)style_song.font.name = '楷體'document.styles['Kai']._element.rPr.rFonts.set(qn('w:eastAsia'), u'楷體') # 將段落中的所有字體style_song = document.styles.add_style('Lishu', WD_STYLE_TYPE.CHARACTER)style_song.font.name = '隸書'document.styles['Lishu']._element.rPr.rFonts.set(qn('w:eastAsia'), u'隸書') # 將段落中的所有字體paragraph1 = document.add_paragraph() # 添加段落run = paragraph1.add_run(u'aBCDefg這是中文', style='Song') # 設置宋體樣式font = run.font #設置字體font.name = 'Cambira' # 設置西文字體paragraph1.add_run(u'aBCDefg這是中文', style='Kai').font.name = 'Cambira'paragraph1.add_run(u'aBCDefg這是中文', style='Lishu').font.name = 'Cambira'document.save('1.docx') |
總結
本篇文章就到這里了，希望能夠給你帶來幫助，也希望您能夠多多關注服務器之家的更多內容！
原文鏈接：https://blog.csdn.net/weixin_44476410/article/details/120943891
