Python openpyxl 產出 Excel 檔案：樣式、多工作表、欄寬與儲存

openpyxl 是功能完整的 Excel (.xlsx) 讀寫庫，支援樣式、公式、多工作表等進階功能。

安裝

easy_install openpyxl
# 或
pip install openpyxl

完整範例

from openpyxl.workbook import Workbook
from openpyxl.writer.excel import ExcelWriter
from openpyxl.cell import get_column_letter
from openpyxl.style import Color, Fill
from openpyxl.cell import Cell

wb = Workbook()
ws = wb.worksheets[0]
ws.title = u"下單統計"

# 寫入儲存格
ws.cell('A1').value = "跟隨總數"
col = get_column_letter(1)
ws.cell('%s%s' % (col, 2)).value = "A2"

# 樣式設定
ws.cell('A2').style.font.color.index = Color.GREEN
ws.cell('A2').style.font.name = 'Arial'
ws.cell('A2').style.font.size = 8
ws.cell('A2').style.font.bold = True
ws.cell('A2').style.alignment.wrap_text = True
ws.cell('A2').style.fill.fill_type = Fill.FILL_SOLID
ws.cell('A2').style.fill.start_color.index = Color.DARKRED

# 欄寬
ws.column_dimensions["C"].width = 60.0

# 新增工作表
ws2 = wb.create_sheet()
ws2.title = u'結單統計'

# 儲存
file_name = 'test.xlsx'
file_dir = '/home/x/'
dest_filename = '%s%s' % (file_dir, file_name)
ew = ExcelWriter(workbook=wb)
ew.save(dest_filename)

注意事項

• 舊版本 API 可能不同，新版建議使用 wb.save(filename)
• 樣式設定在新版中改為 ws['A2'].font = Font(...) 等