python wlsxwriter_python使用xlsxwriter绘图

#coding:utf-8

import xlsxwriter

workbook = xlsxwriter.Workbook('chart_line.xlsx')

worksheet = workbook.add_worksheet()

bold = workbook.add_format({'bold': 1})

# Add the worksheet data to be plotted.

headings = ['time','value']

data = [['A', 'B', 'C','D'],[10, 20, 50,20]]

worksheet.write_row('A1',headings,bold)

worksheet.write_column('A2', data[0])

worksheet.write_column('B2', data[1])

#折线图

chart1 = workbook.add_chart({'type': 'line'})

# Configure the first series.

chart1.add_series({

'name':['Sheet1',0,1],

'categories':['Sheet1',1,0,4,0],

'values':['Sheet1',1,1,4,1],

})

worksheet.insert_chart('D1',chart1,{'x_offset': -10 ,'y_offset': 0})

#柱状图

chart2 = workbook.add_chart({'type': 'column'})

chart2.add_series({

'name':       '=Sheet1!$B$1',

'categories': '=Sheet1!$A$2:$A$5',

'values':     '=Sheet1!$B$2:$B$5',

})

worksheet.insert_chart('D2', chart2, {'x_offset': 500, 'y_offset': 0})

#饼状图

chart3 = workbook.add_chart({'type': 'pie'})

chart3.add_series({

'name':       '=Sheet1!$B$1',

'categories': '=Sheet1!$A$2:$A$5',

'values':     '=Sheet1!$B$2:$B$5',

})

worksheet.insert_chart('D3', chart3, {'x_offset': -10, 'y_offset': 250})

workbook.close()

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10972173/viewspace-2124186/，如需转载，请注明出处，否则将追究法律责任。