需要一个python3编写的利用pymediainfo库统计视频info并写入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文件的第一列是文件名，其余列是视频信息。