Python利用openpyxl进行excel读写

1. 安装

[root@bigdata001 ~]#
[root@bigdata001 ~]# pip3 install openpyxl
[root@bigdata001 ~]#

2. openpyxl进行excel读写Demo

from openpyxl import Workbook
from openpyxl.styles import Font,Alignment
import os


if __name__ == '__main__':

    # 创建表格
    wb = Workbook()
    ws = wb.active

    # 合并单元格
    ws.merge_cells('A1:C1')

    # 写入单元格
    ws['A1'] = 'hello'

    # 写入一行的数据, 从第一列的空白单元格开始
    ws.append(['one', 'two', 'three'])

    # 设置文字粗体和居中对齐
    a1 = ws['A1']
    a1.font = Font(bold=True)
    a1.alignment = Alignment(horizontal="center", vertical="center")

    # 设置列宽
    ws.column_dimensions['A'].width = 20

    # 覆盖方式保存表格
    wb.save(os.getcwd() + '/test.xlsx')

打开test.xlsx，效果如下图：