import os import subprocess import openpyxl import math

安装 openpyxl 模块

pip install openpyxl

安装 mediainfo 命令行工具

sudo apt-get install mediainfo

需要处理的视频文件夹

video_folder = '/home/115/up'

输出 Excel 文件名

excel_file = '/home/115/up/video_info.xlsx'

创建 Excel 文件

wb = openpyxl.Workbook() ws = wb.active ws.title = 'Video Info'

设置表头

headers = ['文件名', '格式', '分辨率', '码率', '帧率', '时长', '大小', '音频编码', '音频采样率', '音频通道数'] for col, header in enumerate(headers, start=1): ws.cell(row=1, column=col, value=header)

获取视频文件列表

video_files = [os.path.join(video_folder, f) for f in os.listdir(video_folder) if f.endswith('.mp4')]

遍历所有视频文件，获取视频信息并写入 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 获取视频信息
result = subprocess.run(['mediainfo', '--Inform=Video;%Format%|%Width%x%Height%|%BitRate/String%|%FrameRate%|%Duration/String3%|Audio;%Format%|%SamplingRate/String%|%Channel(s)%', video_file], stdout=subprocess.PIPE)
output = result.stdout.decode().strip()

# 解析输出结果
video_info, audio_info = output.split('|Audio|')
format, resolution, bitrate, framerate, duration = video_info.split('|')
audio_format, audio_sampling_rate, audio_channel = audio_info.split('|')

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

# 写入 Excel 文件
ws.cell(row=row, column=1, value=file_name)
ws.cell(row=row, column=2, value=format)
ws.cell(row=row, column=3, value=resolution)
ws.cell(row=row, column=4, value=bitrate)
ws.cell(row=row, column=5, value=framerate)
ws.cell(row=row, column=6, value=duration)
ws.cell(row=row, column=7, value=size_str)  # 写入文件大小
ws.cell(row=row, column=8, value=audio_format)  # 写入音频编码
ws.cell(row=row, column=9, value=audio_sampling_rate)  # 写入音频采样率
ws.cell(row=row, column=10, value=audio_channel)  # 写入音频通道数

保存 Excel 文件

wb.save(excel_file) print(f'视频信息已保存到 {excel_file}')