import os import subprocess import openpyxl import math from pydub import AudioSegment

安装openpyxl、pydub模块

pip install openpyxl

pip install pydub

安装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%', video_file], stdout=subprocess.PIPE)
output = result.stdout.decode().strip()

# 解析输出结果
format, resolution, bitrate, framerate, duration = output.split('|')

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

# 获取音频信息
audio = AudioSegment.from_file(video_file)
audio_duration = str(audio.duration_seconds) + 's'
audio_size = str(os.path.getsize(video_file)) + 'B'

# 写入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_duration) # 写入音频时长
ws.cell(row=row, column=9, value=audio_size) # 写入音频大小

保存Excel文件

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