python 使用openpyxl实现读写xlsx文件

import openpyxl

def write_xlsx(value, path, sheet_name='Sheet1'):

    index = len(value)
    workbook = openpyxl.Workbook()
    sheet = workbook.active
    sheet.title = sheet_name
    for i in range(index):
        for j in range(len(value[i])):
            sheet.cell(row=i+1, column=j+1, value=str(value[i][j]))
    workbook.save(path)
    print('xlsx表格写入数据成功！')

def read_xlsx(path, sheet_name='Sheet1'):
    workbook = openpyxl.load_workbook(path)
    sheet = workbook[sheet_name]
    for row in sheet.rows:
        for cell in row:
            print(cell.value, "\t", end="")
        print('\n')
    # print('xlsx表格数据读取成功！')

write_xlsx(detail, data_path, 'Sheet1')
read_xlsx(data_path, 'Sheet1')