获取文件详细信息并将图像加载到电子表格中

import os
from PIL import Image
from openpyxl import Workbook
from openpyxl.drawing.image import Image as ExcelImage

# 获取文件详细信息
def get_file_details(file_path):
    file_name = os.path.basename(file_path)
    file_size = os.path.getsize(file_path)
    created_time = os.path.getctime(file_path)
    modified_time = os.path.getmtime(file_path)
    image_info = get_image_info(file_path)
    return file_name, file_size, created_time, modified_time, image_info

# 获取图像信息
def get_image_info(image_path):
    image = Image.open(image_path)
    width, height = image.size
    mode = image.mode
    return width, height, mode

# 加载图像到电子表格
def load_image_to_excel(file_path, excel_file):
    file_name, file_size, created_time, modified_time, image_info = get_file_details(file_path)
    
    # 创建Excel工作簿和工作表
    workbook = Workbook()
    sheet = workbook.active
    
    # 写入文件详细信息
    sheet['A1'] = 'File Name'
    sheet['B1'] = 'File Size'
    sheet['C1'] = 'Created Time'
    sheet['D1'] = 'Modified Time'
    sheet['E1'] = 'Image Width'
    sheet['F1'] = 'Image Height'
    sheet['G1'] = 'Image Mode'
    
    sheet['A2'] = file_name
    sheet['B2'] = file_size
    sheet['C2'] = created_time
    sheet['D2'] = modified_time
    sheet['E2'] = image_info[0]
    sheet['F2'] = image_info[1]
    sheet['G2'] = image_info[2]
    
    # 加载图像到电子表格
    img = ExcelImage(file_path)
    sheet.add_image(img, 'H2')
    
    # 保存电子表格文件
    workbook.save(excel_file)

# 示例用法
file_path = 'path/to/image.jpg'
excel_file = 'path/to/output.xlsx'
load_image_to_excel(file_path, excel_file)