本文實(shí)例為大家分享了python xlsxwriter創(chuàng)建excel圖表的具體代碼，供大家參考，具體內(nèi)容如
|
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
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
|
#coding=utf-8 import xlsxwriter from xlsxwriter.workbook import Workbook from xlrd.sheet import Sheet def demo1(): import xlsxwriter # 創(chuàng)建excel文件 workbook = xlsxwriter.Workbook('demo.xlsx') # 添加worksheet,也可以指定名字 worksheet = workbook.add_worksheet() worksheet = workbook.add_worksheet('Test') #設(shè)置第一列的寬度 worksheet.set_column('A:A', len('hello ')+1) #添加一個(gè)加粗格式方便后面使用 bold = workbook.add_format({'bold': True}) #在A1單元格寫入純文本 worksheet.write('A1', 'Hello') #在A2單元格寫入帶格式的文本 worksheet.write('A2', 'World', bold) #指定行列寫入數(shù)字，下標(biāo)從0開始 worksheet.write(2, 0, 123) worksheet.write(3, 0, 123.456) #在B5單元格插入圖片 worksheet.insert_image('B5', 'python-logo.png') workbook.close() def charts(): workbook = xlsxwriter.Workbook('chart_column.xlsx') worksheet = workbook.add_worksheet() bold = workbook.add_format({'bold': 1}) # 這是個(gè)數(shù)據(jù)table的列 headings = ['Number', 'Batch 1', 'Batch 2'] data = [ [2, 3, 4, 5, 6, 7], [10, 40, 50, 20, 10, 50], [30, 60, 70, 50, 40, 30], ] #寫入一行 worksheet.write_row('A1', headings, bold) #寫入一列 worksheet.write_column('A2', data[0]) worksheet.write_column('B2', data[1]) worksheet.write_column('C2', data[2]) ############################################ #創(chuàng)建一個(gè)圖表，類型是column chart1 = workbook.add_chart({'type': 'column'}) # 配置series,這個(gè)和前面worksheet是有關(guān)系的。 # 指定圖表的數(shù)據(jù)范圍 chart1.add_series({ 'name': '=Sheet1!$B$1', 'categories': '=Sheet1!$A$2:$A$7', 'values': '=Sheet1!$B$2:$B$7', }) chart1.add_series({ 'name': "=Sheet1!$C$1", 'categories': '=Sheet1!$A$2:$A$7', 'values': '=Sheet1!$C$2:$C$7', }) # 配置series的另一種方法 # # [sheetname, first_row, first_col, last_row, last_col] # chart1.add_series({ # 'name': ['Sheet1',0,1], # 'categories': ['Sheet1',1,0,6,0], # 'values': ['Sheet1',1,1,6,1], # }) # # # # chart1.add_series({ # 'name': ['Sheet1', 0, 2], # 'categories': ['Sheet1', 1, 0, 6, 0], # 'values': ['Sheet1', 1, 2, 6, 2], # }) # 添加圖表標(biāo)題和標(biāo)簽 chart1.set_title ({'name': 'Results of sample analysis'}) chart1.set_x_axis({'name': 'Test number'}) chart1.set_y_axis({'name': 'Sample length (mm)'}) # 設(shè)置圖表風(fēng)格 chart1.set_style(11) # 在D2單元格插入圖表（帶偏移） worksheet.insert_chart('D2', chart1, {'x_offset': 25, 'y_offset': 10}) ####################################################################### # # 創(chuàng)建一個(gè)疊圖子類型 chart2 = workbook.add_chart({'type': 'column', 'subtype': 'stacked'}) # Configure the first series. chart2.add_series({ 'name': '=Sheet1!$B$1', 'categories': '=Sheet1!$A$2:$A$7', 'values': '=Sheet1!$B$2:$B$7', }) # Configure second series. chart2.add_series({ 'name': '=Sheet1!$C$1', 'categories': '=Sheet1!$A$2:$A$7', 'values': '=Sheet1!$C$2:$C$7', }) # Add a chart title and some axis labels. chart2.set_title ({'name': 'Stacked Chart'}) chart2.set_x_axis({'name': 'Test number'}) chart2.set_y_axis({'name': 'Sample length (mm)'}) # Set an Excel chart style. chart2.set_style(12) # Insert the chart into the worksheet (with an offset). worksheet.insert_chart('D18', chart2, {'x_offset': 25, 'y_offset': 10}) ####################################################################### # # Create a percentage stacked chart sub-type. # chart3 = workbook.add_chart({'type': 'column', 'subtype': 'percent_stacked'}) # Configure the first series. chart3.add_series({ 'name': '=Sheet1!$B$1', 'categories': '=Sheet1!$A$2:$A$7', 'values': '=Sheet1!$B$2:$B$7', }) # Configure second series. chart3.add_series({ 'name': '=Sheet1!$C$1', 'categories': '=Sheet1!$A$2:$A$7', 'values': '=Sheet1!$C$2:$C$7', }) # Add a chart title and some axis labels. chart3.set_title ({'name': 'Percent Stacked Chart'}) chart3.set_x_axis({'name': 'Test number'}) chart3.set_y_axis({'name': 'Sample length (mm)'}) # Set an Excel chart style. chart3.set_style(13) # Insert the chart into the worksheet (with an offset). worksheet.insert_chart('D34', chart3, {'x_offset': 25, 'y_offset': 10}) #生成圓餅圖 chart4 = workbook.add_chart({'type':'pie'}) #定義數(shù)據(jù) data = [ ['Pass','Fail','Warn','NT'], [333,11,12,22], ] #寫入數(shù)據(jù) worksheet.write_row('A51',data[0],bold) worksheet.write_row('A52',data[1]) chart4.add_series({ 'name': '接口測(cè)試報(bào)表圖', 'categories': '=Sheet1!$A$51:$D$51', 'values': '=Sheet1!$A$52:$D$52', 'points':[ {'fill':{'color':'#00CD00'}}, {'fill':{'color':'red'}}, {'fill':{'color':'yellow'}}, {'fill':{'color':'gray'}}, ], }) # Add a chart title and some axis labels. chart4.set_title ({'name': '接口測(cè)試統(tǒng)計(jì)'}) chart4.set_style(3) # chart3.set_y_axis({'name': 'Sample length (mm)'}) worksheet.insert_chart('E52', chart4, {'x_offset': 25, 'y_offset': 10}) workbook.close() if __name__ == '__main__': # demo1() charts() print('finished...') pass |
效果如下
參考文檔：
https://pypi.python.org/pypi/XlsxWriter
python使用xlsxwriter打造excel周報(bào)日周的統(tǒng)計(jì)圖表
以上就是本文的全部?jī)?nèi)容，希望對(duì)大家的學(xué)習(xí)有所幫助，也希望大家多多支持服務(wù)器之家。
原文鏈接：https://blog.csdn.net/pegsa/article/details/52729250
