python实现数据写入excel表格

Python  /  管理员 发布于 7年前   122

本文实例为大家分享了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.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()

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。