xlsxwriter

from xlsxwriter.workbook import Workbook


workbook = Workbook(filename='shishi.xlsx')
worksheet = workbook.add_worksheet()
red_color = workbook.add_format({'color': 'red', 'bold': True})
"""構(gòu)建字體顏色"""
wl = ['abcd', 'efgh']
# 有顏色用 富文本      
worksheet.write_rich_string(0, 0, wl[0], red_color, wl[1])   要哪個(gè)字符串變顏色瑞妇，就把顏色放在哪個(gè)的前面
# 沒(méi)顏色直接寫入
worksheet.write(0, 1, 'ccss')
worksheet.write(0, 2, 3)
worksheet.write_row('A1', wl, red_color)   寫入一整行 從哪個(gè)單元格開始就寫哪個(gè)單元格
workbook.close()

openpyxl

from openpyxl import Workbook
from openpyxl.styles import Font  # 導(dǎo)入字體模塊


wb = Workbook()
sheet = wb.active
Color = 'ffc7ce'

font = Font(u'等線', size=11, bold=False, italic=False, strike=False, color=Color)  # 設(shè)置字體樣式
sheet.cell(row=i, column=1, value="哈哈").font = font # 序列
sheet.merge_cells('A1:B1')
wb.save('shishi.xlsx')


def cell_format():
    from openpyxl.styles import Border, Side, Font, Alignment, NamedStyle, PatternFill
    format_all = {}
    # 設(shè)置邊框
    border_type = Side(border_style='thin', color='000000')
    border = Border(left=border_type, right=border_type, top=border_type, bottom=border_type)
    # 設(shè)置對(duì)齊
    align = Alignment(horizontal='center', vertical='center', wrap_text=False)
    # 設(shè)置字體顏色大小
    font = Font(bold=False, name='等線', color="000000")  # size=11,

    # 設(shè)置背景色
    title_fill = PatternFill(fill_type='solid', start_color='C0C0C0')  # 灰

    title_format = NamedStyle(name='title_format', border=border, fill=title_fill, alignment=align, font=font)
    normal_format = NamedStyle(name='normal_format', border=border, alignment=align, font=font)

    format_all['title_format'] = title_format
    format_all['normal_format'] = normal_format
    return format_all

format_all = cell_format()  # 調(diào)用
for cell in list(ws.rows)[0]:
    cell.style = format_all['title_format']
for row in ws.iter_rows(min_row=2):
    for cell in row:
        cell.style = format_all['normal_format']

# 設(shè)置行高
ws.row_dimensions[1].height = 20
# 設(shè)置列寬
from openpyxl.utils import get_column_letter
for i in range(1, ws.max_column + 1):
    if i == 1:
        ws.column_dimensions[get_column_letter(1)].width = 8
    else:
        ws.column_dimensions[get_column_letter(i)].width = 18
    

xlwt

import xlwt


content_font = xlwt.Font()
# content_font.name = '宋體'
# content_font.height = 20 * 12  # 字體大小  20位衡量單位
# content_font.bold = False  # 加粗
# content_font.underline = False  # 下劃線
# content_font.italic = True  # 斜體
content_font.colour_index = 0x0A
wl = ['abcd', 'efgh']
workbook = xlwt.Workbook(encoding = 'utf-8')
sheet = workbook.add_sheet('sheet1')
sheet.write_rich_text(0, 0, [[wl[0], content_font], wl[1]])
workbook.save('shishi.xlsx')