本文实例为大家分享了python数据写入excel表格的具体代码，供大家参考，具体内容如下
安装： xlsxwriter第三方库
code：
|
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
|
#!/usr/bin/env/python#_*_coding:utf-8_*_#Data:2017-08-13#Auther:苏莫#Link:http://blog.csdn.net/lingluofengzang#PythonVersion:python2.7#filename:xlsx.pyimport sys# import osimport xlsxwriter'''pip install xlsxwriter'''reload(sys)sys.setdefaultencoding("utf-8")# path = os.path.dirname(os.path.abspath(__file__))# 建立文件workbook = xlsxwriter.Workbook("text.xlsx")# 可以制定表的名字# worksheet = workbook.add_worksheet('text')worksheet = workbook.add_worksheet()# 设置列宽# worksheet.set_column('A:A',10)# 设置祖体bold = workbook.add_format({'bold':True})# 定义数字格式# money = workbook.add_format({'num_format':'$#,##0'})# 写入带粗体的数据worksheet.write('A1','data',bold)worksheet.write('B1','work')'''worksheet.write(0, 0, 'Hello') # write_string()worksheet.write(1, 0, 'World') # write_string()worksheet.write(2, 0, 2) # write_number()worksheet.write(3, 0, 3.00001) # write_number()worksheet.write(4, 0, '=SIN(PI()/4)') # write_formula()worksheet.write(5, 0, '') # write_blank()worksheet.write(6, 0, None) # write_blank()'''worksheet.write('A3',15)worksheet.write('B3',20)worksheet.write('C3',44)worksheet.write('D3',36)# xlsx计算数据worksheet.write('E3','=SUM(A3:D3)')'''建立Chart对象： chart = workbook.add_chart({type, 'column'})Chart: Area, Bar, Column, Doughnut, Line, Pie, Scatter, Stock, Radar将图插入到sheet中： worksheet.insert_chart('A7', chart)'''# 定义插入的图标样式chart = workbook.add_chart({"type":'column'})headings = ['a','b','c']data = [ [1,2,3,4,5], [2,4,6,8,10], [3,6,9,12,15],]# 按行插入数据worksheet.write_row('A4',headings)# 按列插入数据worksheet.write_column('A5',data[0])worksheet.write_column('B5',data[1])worksheet.write_column('C5',data[2])# 图行的数据区# name：代表图例名称；# categories：是x轴项，也就是类别；# values:是y轴项，也就是值；chart.add_series({ 'name':'=Sheet1!$B$4', 'categories':'=Sheet1!$A$5:$A$9', 'values':'=Sheet1!$B$5:$B$9',})chart.add_series({ 'name':['Sheet1', 3, 2], 'categories':['Sheet1', 4, 0, 8, 0], 'values':['Sheet1', 4, 2, 8, 2],})# 图形的标题chart.set_title ({'name': 'Percent Stacked Chart'})# 图形X轴的说明chart.set_x_axis({'name': 'Test number'})# 图形Y轴的说明chart.set_y_axis({'name': 'Sample length (mm)'})# 设置图表风格chart.set_style(11)# 插入图形,带偏移worksheet.insert_chart('D12',chart,{'x_offset': 25, 'y_offset': 10})workbook.close() |
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。
原文链接：https://blog.csdn.net/lingluofengzang/article/details/78209237
