python操作excel，只支持xlsx

code

# coding=utf-8

import openpyxl
from openpyxl import load_workbook
from openpyxl.styles import Font, colors


def write(file_name, sheet_name, title, rows):
    wb = openpyxl.Workbook()
    sheet = wb.create_sheet(index=0, title=sheet_name)
    sheet.append(title)
    for row in rows:
        sheet.append(row)
    wb.save(file_name)


def read(file_name, sheet_name, row_begin_no=2):
    wb = load_workbook(file_name, read_only=True)
    sheet = wb.get_sheet_by_name(sheet_name)
    sheet_data = []
    flag = 0
    for r in sheet.rows:
        flag += 1
        if flag < row_begin_no:
            continue
        sheet_data.append(r)
    return sheet_data


def modify_style(file_name, sheet_name, cell_list):
    wb = load_workbook(filename=file_name)
    sheet = wb[sheet_name]
    bold_16_font = Font(size=16, bold=True)
    sheet.row_dimensions[1].height = 20
    sheet.column_dimensions['A'].width = 12
    sheet.column_dimensions['B'].width = 50
    sheet.column_dimensions['C'].width = 12
    sheet.column_dimensions['D'].width = 12
    sheet.column_dimensions['D'].width = 12
    sheet.column_dimensions['F'].width = 50
    sheet.column_dimensions['G'].width = 50
    sheet.column_dimensions['H'].width = 50
    for cell in cell_list:
        top_row_cell = sheet[cell]
        top_row_cell.font = bold_16_font
    wb.save(file_name)
    wb.close()