下面python3代码当路径下无视频文件时不打印已处理 success_counttotal_count 共计import osimport reimport subprocessimport openpyxlimport mathfrom openpyxlstyles import Font PatternFill Alignment# 视频格式supported_formats = m
修改如下:
文件路径
path = input('请输入文件路径:') if os.path.isfile(path): # 1个文件 total_count += 1 total_count = 1 process_video(path) elif os.path.isdir(path): process_folder(path)
if total_count == 0: print('无可处理文件或路径为空') elif success_count == 0: print('路径下无视频文件') else: # 设置对齐 l_col = ws['L'] for cell in l_col: cell.alignment = Alignment(horizontal='left') m_col = ws['M'] for cell in m_col: cell.alignment = Alignment(horizontal='center')
# 设置total_count项字体加粗
total_count_cell = ws.cell(row=2, column=13)
total_count_cell.font = Font(bold=True, color='FF0000')
# 不固定列宽
for col in ws.columns:
col_letter = col[0].column_letter
if col_letter not in ['C', 'H']:
ws.column_dimensions[col_letter].width = 11
# 保存Excel文件
if not os.path.exists(excel_folder):
os.makedirs(excel_folder)
excel_file_path = os.path.join(excel_folder, excel_file)
wb.save(excel_file_path)
# 打印处理失败文件个数和总计处理文件数
print(
f'已完成,处理成功 {success_count} 个文件,处理失败 {failed_count} 个文件,视频信息已保存到 {excel_file_path}'
)
原文地址: https://www.cveoy.top/t/topic/be3s 著作权归作者所有。请勿转载和采集!