from openpyxl import Workbook
from openpyxl.chart import BarChart, Reference

wb = Workbook(write_only=True)
sheet = wb.create_sheet()

rows = [
    ('類別', '銷售A組', '銷售B組'),
    ('手機', 40, 30),
    ('平板', 50, 60),
    ('筆記本', 80, 70),
    ('外圍設備', 20, 10),
]

# 向表單中添加行
for row in rows:
    sheet.append(row)

# 創建圖表對象
chart = BarChart()
chart.type = 'col'
chart.style = 10
# 設置圖表的標題
chart.title = '銷售統計圖'
# 設置圖表縱軸的標題
chart.y_axis.title = '銷量'
# 設置圖表橫軸的標題
chart.x_axis.title = '商品類別'
# 設置數據的范圍
data = Reference(sheet, min_col=2, min_row=1, max_row=5, max_col=3)
# 設置分類的范圍
cats = Reference(sheet, min_col=1, min_row=2, max_row=5)
# 給圖表添加數據
chart.add_data(data, titles_from_data=True)
# 給圖表設置分類
chart.set_categories(cats)
chart.shape = 4
# 將圖表添加到表單指定的單元格中
sheet.add_chart(chart, 'A10')

wb.save('demo.xlsx')

import random

import xlwt

student_names = ['關羽', '張飛', '趙云', '馬超', '黃忠']
scores = [[random.randrange(50, 101) for _ in range(3)] for _ in range(5)]
# 創建工作簿對象（Workbook）
wb = xlwt.Workbook()
# 創建工作表對象（Worksheet）
sheet = wb.add_sheet('一年級二班')
# 添加表頭數據
titles = ('姓名', '語文', '數學', '英語')
for index, title in enumerate(titles):
    sheet.write(0, index, title)
# 將學生姓名和考試成績寫入單元格
for row in range(len(scores)):
    sheet.write(row + 1, 0, student_names[row])
    for col in range(len(scores[row])):
        sheet.write(row + 1, col + 1, scores[row][col])
# 保存Excel工作簿
wb.save('考試成績表.xls')