本文实例为大家分享了python数据写入excel表格的具体代码,供大家参考,具体内容如下
安装: xlsxwriter第三方库
code:
#!/usr/bin/env/python
#_*_coding:utf-8_*_
#Data:2017-08-13
#Auther:苏莫
#Link:http://blog.csdn.net/lingluofengzang
#PythonVersion:python2.7
#filename:xlsx.py
import sys
# import os
import 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()
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持我们。
本文标题: python实现数据写入excel表格
本文地址: http://www.cppcns.com/jiaoben/python/223679.html