如何用Python中19行代码把照片写入到Excel中

我们可以使用Python的Pillow库读取图片，然后使用openpyxl库将图像写入Excel单元格。其中19行包括导入模块和定义函数等步骤，具体步骤如下：

1.导入Python的Pillow和openpyxl库。

from PIL import Image
from openpyxl import Workbook

2.创建Excel文件和工作表对象。

workbook = Workbook()
sheet = workbook.active

3.打开要写入的图片文件，并读取图片的宽度和高度。

img = Image.open("example.jpg")
width, height = img.size

4.遍历像素，将图片中每个像素的RGB值写入Excel单元格。

for x in range(1, width + 1):
    for y in range(1, height + 1):
        r, g, b = img.getpixel((x - 1, y - 1))
        hex_color = f"{r:02X}{g:02X}{b:02X}"
        cell = sheet.cell(row=y, column=x, value=hex_color)

5.将图片路径写入Excel文件的A1单元格。

sheet.cell(row=1, column=1, value="example.jpg")

6.保存Excel文件。

workbook.save("example.xlsx")

以下是完整的示例代码：

from PIL import Image
from openpyxl import Workbook


def convert_image_to_excel(image_path, excel_path):
    # Create workbook and sheet objects
    workbook = Workbook()
    sheet = workbook.active

    # Open the image and get its dimensions
    img = Image.open(image_path)
    width, height = img.size

    # Write the image pixel data to the sheet
    for x in range(1, width + 1):
        for y in range(1, height + 1):
            r, g, b = img.getpixel((x - 1, y - 1))
            hex_color = f"{r:02X}{g:02X}{b:02X}"
            cell = sheet.cell(row=y, column=x, value=hex_color)

    # Write the image path to cell A1
    sheet.cell(row=1, column=1, value=image_path)

    # Save the workbook
    workbook.save(excel_path)


# Example usage
convert_image_to_excel("example.jpg", "example.xlsx")

我们还可以使用多张图片进行相同的操作，以下是示例代码：

from PIL import Image
from openpyxl import Workbook


def convert_images_to_excel(image_paths, excel_path):
    # Create workbook and sheet objects
    workbook = Workbook()
    sheet = workbook.active

    # Loop through each image and write to the sheet
    for i, image_path in enumerate(image_paths, start=1):
        # Open the image and get its dimensions
        img = Image.open(image_path)
        width, height = img.size

        # Write the image pixel data to the sheet
        for x in range(1, width + 1):
            for y in range(1, height + 1):
                r, g, b = img.getpixel((x - 1, y - 1))
                hex_color = f"{r:02X}{g:02X}{b:02X}"
                sheet.cell(row=y, column=(i * 3) - 2, value=hex_color)

        # Write the image path to cell A1
        sheet.cell(row=1, column=(i * 3) - 2, value=image_path)

    # Save the workbook
    workbook.save(excel_path)


# Example usage
image_paths = ["example1.jpg", "example2.jpg", "example3.jpg"]
convert_images_to_excel(image_paths, "examples.xlsx")

以上是用Python将图片写入Excel的详细攻略，希望能对您有所帮助。