Python3 脚本：统计视频信息并写入 Excel

以下是一个 Python3 编写的脚本，可以统计视频大小、时长、比特率、帧率、宽度、高度等信息并写入 Excel：

import os
import subprocess
import openpyxl

# 获取视频信息
def get_video_info(video_path):
    cmd = 'ffprobe -v error -select_streams v:0 -show_entries stream=width,height,duration,bit_rate,r_frame_rate -of csv=p=0 ' + '''' + video_path + ''''
    output = subprocess.check_output(cmd, shell=True)
    info = output.decode().strip().split(',')
    width = info[0]
    height = info[1]
    duration = info[2]
    bitrate = info[3]
    fps = eval(info[4])
    return width, height, duration, bitrate, fps

# 获取文件大小
def get_file_size(video_path):
    size = os.path.getsize(video_path)
    return size

# 写入excel
def write_to_excel(video_path, width, height, duration, bitrate, fps, size, excel_path):
    wb = openpyxl.load_workbook(excel_path)
    ws = wb.active
    ws.append([video_path, width, height, duration, bitrate, fps, size])
    wb.save(excel_path)

if __name__ == '__main__':
    video_path = 'test.mp4'
    excel_path = 'video_info.xlsx'

    width, height, duration, bitrate, fps = get_video_info(video_path)
    size = get_file_size(video_path)

    write_to_excel(video_path, width, height, duration, bitrate, fps, size, excel_path)

你需要修改video_path和excel_path变量来指定视频文件路径和 Excel 文件路径。执行脚本后，它将统计视频的相关信息，并将其写入 Excel 文件。