在代码中增加已完成文件计数的变量和输出即可。具体可参考以下代码：

已完成文件计数

count = 0

遍历所有视频文件，获取视频信息、音频信息和音频语言，并写入Excel文件

for row, video_file in enumerate(video_files, start=2): # 获取文件名 file_name = os.path.basename(video_file)

# 获取文件大小并进行单位换算
size = os.path.getsize(video_file)
if size < 1024:
    size_str = f'{size} B'
elif size < 1024 * 1024:
    size_str = f'{size / 1024:.2f} KiB'
elif size < 1024 * 1024 * 1024:
    size_str = f'{size / 1024 / 1024:.2f} MiB'
else:
    size_str = f'{size / 1024 / 1024 / 1024:.2f} GiB'

# 使用mediainfo获取视频信息 / 音频信息和音频语言
video_result = subprocess.run(['mediainfo', '--Inform=Video;%Format%|%Width%x%Height%|%BitRate/String%|%FrameRate%|%Duration/String3%', video_file], stdout=subprocess.PIPE)
video_output = video_result.stdout.decode().strip()
audio_result = subprocess.run(['mediainfo', '--Inform=Audio;%BitRate/String%|%SamplingRate/String%|%Language/String%', video_file], stdout=subprocess.PIPE)
audio_output = audio_result.stdout.decode().strip()

# 解析输出结果
format, resolution, bitrate, framerate, duration = video_output.split('|')
audiobitrate, audiosamplingrate, audiolang = audio_output.split('|')

# 时长取整
duration = duration.split('.')[0]
h, m, s = duration.split(':')
duration = f'{h}:{m}:{math.ceil(float(s))}'

# 以分钟计算的时长
duration_minutes = int(h) * 60 + int(m) + math.ceil(float(s)) / 60

# 计算压缩比率
ratio = round(duration_minutes / size * 1000000000, 2)

# 使用正则表达式替换码率数据中第一个数字和第二个数字之间的空格
bitrate = re.sub(pattern, r'\1\2', bitrate)

# 写入Excel文件
ws.cell(row=row, column=1, value=file_name)
ws.cell(row=row, column=2, value=os.path.dirname(video_file)) # 写入文件夹路径
ws.cell(row=row, column=3, value=format)
ws.cell(row=row, column=4, value=size_str) # 写入文件大小
ws.cell(row=row, column=5, value=duration)
ws.cell(row=row, column=6, value=resolution)
ws.cell(row=row, column=7, value=bitrate)
ws.cell(row=row, column=8, value=framerate)
ws.cell(row=row, column=9, value=audiobitrate)
ws.cell(row=row, column=10, value=audiosamplingrate)
ws.cell(row=row, column=11, value=audiolang)
ws.cell(row=row, column=12, value=ratio)

# 已完成文件计数加1
count += 1
print(f'已处理 {count}/{len(video_files)} 个视频文件')

自动调整列宽

for col in ws.columns: max_length = 0 column = col[0].column_letter for cell in col: try: if len(str(cell.value)) > max_length: max_length = len(str(cell.value)) except: pass adjusted_width = (max_length + 2) ws.column_dimensions[column].width = adjusted_width + 1

调整L列的列宽和对齐方式

l_col = ws['L'] max_length = 0 for cell in l_col: try: if len(str(cell.value)) > max_length: max_length = len(str(cell.value)) except: pass l_col_width = max_length + 5 # 列宽加5 ws.column_dimensions['L'].width = l_col_width for cell in l_col: cell.alignment = Alignment(horizontal='left') # 左对齐

保存Excel文件

if not os.path.exists(excel_folder): os.makedirs(excel_folder) excel_file_path = os.path.join(excel_folder, excel_file) wb.save(excel_file_path) print(f'已处理完所有视频文件，视频信息已保存到 {excel_file_path}')