python

在第一列插入一列日期：

执行代码后如下所示：

# coding:utf-8
from openpyxl import Workbook, load_workbook
file_info = './excel_test/1.xlsx'
wb = load_workbook(file_info)
ws = wb.worksheets[0]
ws.insert_cols(1)
for index, row in enumerate(ws.rows):
    if index == 0:
        row[0].value = '日期'
    else:
        row[0].value = '2020-08-27'

wb.save('./excel_test/3.xlsx')

# row[0]与insert_cols(1)有对应关系，两者相差1