-
StackOverflow 文件
-
Python Language 教程
-
Python 和 Excel
-
使用 xlsxwriter 建立 excel 圖表
import xlsxwriter
# sample data
chart_data = [
{'name': 'Lorem', 'value': 23},
{'name': 'Ipsum', 'value': 48},
{'name': 'Dolor', 'value': 15},
{'name': 'Sit', 'value': 8},
{'name': 'Amet', 'value': 32}
]
# excel file path
xls_file = 'chart.xlsx'
# the workbook
workbook = xlsxwriter.Workbook(xls_file)
# add worksheet to workbook
worksheet = workbook.add_worksheet()
row_ = 0
col_ = 0
# write headers
worksheet.write(row_, col_, 'NAME')
col_ += 1
worksheet.write(row_, col_, 'VALUE')
row_ += 1
# write sample data
for item in chart_data:
col_ = 0
worksheet.write(row_, col_, item['name'])
col_ += 1
worksheet.write(row_, col_, item['value'])
row_ += 1
# create pie chart
pie_chart = workbook.add_chart({'type': 'pie'})
# add series to pie chart
pie_chart.add_series({
'name': 'Series Name',
'categories': '=Sheet1!$A$3:$A$%s' % row_,
'values': '=Sheet1!$B$3:$B$%s' % row_,
'marker': {'type': 'circle'}
})
# insert pie chart
worksheet.insert_chart('D2', pie_chart)
# create column chart
column_chart = workbook.add_chart({'type': 'column'})
# add serie to column chart
column_chart.add_series({
'name': 'Series Name',
'categories': '=Sheet1!$A$3:$A$%s' % row_,
'values': '=Sheet1!$B$3:$B$%s' % row_,
'marker': {'type': 'circle'}
})
# insert column chart
worksheet.insert_chart('D20', column_chart)
workbook.close()
結果: