Python 脚本：使用 pymediainfo 获取视频信息并写入 Excel

以下是一个简单的 Python3 脚本，使用 'pymediainfo' 库来获取视频的信息并将其写入 Excel 文件中。在运行脚本之前，请确保已经安装了 'pymediainfo' 库和 'openpyxl' 库。

import os
import sys
import openpyxl
from pymediainfo import MediaInfo


def get_video_info(file_path):
    media_info = MediaInfo.parse(file_path)
    video_track = media_info.tracks[0]
    duration = video_track.duration / 1000
    width = video_track.width
    height = video_track.height
    frame_rate = video_track.frame_rate
    codec = video_track.codec
    return duration, width, height, frame_rate, codec


def write_to_excel(excel_file_path, video_files):
    wb = openpyxl.Workbook()
    ws = wb.active
    ws.title = 'Video Info'
    ws.append(['File Name', 'Duration (s)', 'Width', 'Height', 'Frame Rate', 'Codec'])

    for video_file in video_files:
        file_name = os.path.basename(video_file)
        duration, width, height, frame_rate, codec = get_video_info(video_file)
        ws.append([file_name, duration, width, height, frame_rate, codec])

    wb.save(excel_file_path)


if __name__ == '__main__':
    if len(sys.argv) < 3:
        print('Usage: python3 video_info_to_excel.py [video_directory] [excel_file_path]')
        sys.exit(1)

    video_directory = sys.argv[1]
    excel_file_path = sys.argv[2]
    video_files = [os.path.join(video_directory, file_name) for file_name in os.listdir(video_directory)]
    write_to_excel(excel_file_path, video_files)

该脚本接受两个命令行参数：视频目录的路径和 Excel 文件的路径。它将获取视频目录中所有视频文件的信息，并将其写入 Excel 文件中。Excel 文件的第一列是文件名，其余列是视频信息。