excel插入一列日期 pandas_如何使用Pandas为excel文档添加时间戳？

应用thisSO问题的答案，这里是您代码的更新版本，其中包含我所做更改的注释：import subprocess as sp, pandas as pd

# (1) new import

from openpyxl import load_workbook

# (2) new import

from datetime import datetime

ffmpeg = 'C:/FFMPEG/bin/ffmpeg.exe' # on Windows

datafile = r'C:\Users\A_Do\Dropbox\1. Projects\2. Python\TM Creator\tm_creator_test1.xlsx'

# (3) open the file in openpyxl first:

book = load_workbook(datafile)

xl = pd.ExcelFile(datafile,index = False)

df = xl.parse('Sheet1')

def create_tm():

row_iterator = df.iterrows()

# take first item from row_iterator

for i, row in row_iterator:

infile = row['filename']

outputfile = row['outputfilename']

timein = row['timein']

duration = row['duration']

d