使用mediainfo获取语言信息

language_result = subprocess.run(["mediainfo", "--Inform=Audio;%Language/String%", video_file], stdout=subprocess.PIPE) language_output = language_result.stdout.decode().strip()

解析语言信息

language = language_output.split("|")[0]

写入Excel文件

ws.cell(row=row, column=11, value=language) # 写入音频语言

更新表头

headers = ["文件名", "文件路径", "格式", "大小", "时长", "分辨率", "码率", "帧率", "音频码率", "音频采样率", "音频语言"] for col, header in enumerate(headers, start=1): cell = ws.cell(row=1, column=col, value=header) cell.font = header_font cell.fill = header_fill cell.alignment = header_alignment

自动调整列宽

for col in ws.columns: max_length = 0 column = col[0].column_letter for cell in col: try: if len(str(cell.value)) > max_length: max_length = len(str(cell.value)) except: pass adjusted_width = (max_length + 2) ws.column_dimensions[column].width = adjusted_width

保存Excel文件

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