如何使用 Python 將圖片插入 Excel

Step 1: Install the IronXL for Python Package.

Make sure you have created a Python file with a .py extension. Now install the IronXL package using pip:

pip install IronXL

pip install IronXL

Step 2: Create or Open an Excel Workbook.

Create an Excel file or open an existing Excel file using IronXL.

import ironxl

# To create a new Excel workbook
workbook = ironxl.Workbook()

# Or to open an existing Excel workbook
workbook = ironxl.Workbook('existing_file.xlsx')

import ironxl

# To create a new Excel workbook
workbook = ironxl.Workbook()

# Or to open an existing Excel workbook
workbook = ironxl.Workbook('existing_file.xlsx')

Step 3: Select the Worksheet where the image will be inserted.

# Create a new worksheet
worksheet = workbook.add_worksheet('Sheet1')

# Or access an existing worksheet
worksheet = workbook.get_worksheet('Sheet1')

# Alternatively, use the default worksheet
worksheet = workbook.DefaultWorkSheet

# Create a new worksheet
worksheet = workbook.add_worksheet('Sheet1')

# Or access an existing worksheet
worksheet = workbook.get_worksheet('Sheet1')

# Alternatively, use the default worksheet
worksheet = workbook.DefaultWorkSheet

Step 4: Insert the Image at a Specified Location.

# Specify the path to your image file
image_path = "ironXL.jpg"
# Specify the cell where you want to insert the image
cell_location = 'B2'
# Insert the image into the specified cell
worksheet.insert_image(cell_location, image_path)

# Specify the path to your image file
image_path = "ironXL.jpg"
# Specify the cell where you want to insert the image
cell_location = 'B2'
# Insert the image into the specified cell
worksheet.insert_image(cell_location, image_path)

Step 5: Save the Workbook.

# Save the workbook with the desired filename
workbook.save('AwesomeIronXL.xlsx')

# Save the workbook with the desired filename
workbook.save('AwesomeIronXL.xlsx')

Full Code Example

import ironxl

# Step 1: Create a new Excel workbook or open an existing one
workbook = ironxl.Workbook()  # For a new Excel file
# workbook = ironxl.Workbook('existing_file.xlsx')  # For an existing workbook

# Step 2: Select a worksheet from a list of worksheets or create a new one
# worksheet = workbook.add_worksheet('Sheet1')  # Create a new worksheet
# worksheet = workbook.get_worksheet('Sheet1')  # Access an existing worksheet
worksheet = workbook.DefaultWorkSheet

# Step 3: Insert an image
image_path = "ironXL.jpg"  # Path to your image file
cell_location = 'B2'  # Specify the Excel cell for image insertion
worksheet.insert_image(cell_location, image_path)  # Insert the image

# Step 4: Save the workbook
workbook.save('AwesomeIronXL.xlsx')

import ironxl

# Step 1: Create a new Excel workbook or open an existing one
workbook = ironxl.Workbook()  # For a new Excel file
# workbook = ironxl.Workbook('existing_file.xlsx')  # For an existing workbook

# Step 2: Select a worksheet from a list of worksheets or create a new one
# worksheet = workbook.add_worksheet('Sheet1')  # Create a new worksheet
# worksheet = workbook.get_worksheet('Sheet1')  # Access an existing worksheet
worksheet = workbook.DefaultWorkSheet

# Step 3: Insert an image
image_path = "ironXL.jpg"  # Path to your image file
cell_location = 'B2'  # Specify the Excel cell for image insertion
worksheet.insert_image(cell_location, image_path)  # Insert the image

# Step 4: Save the workbook
workbook.save('AwesomeIronXL.xlsx')

Explanation of the Code

1. Creating/Opening a Workbook: You can either create a new workbook or open an existing one using the ironxl.Workbook() function. For an existing Excel file, ensure you provide the correct file path to the workbook.

2. Selecting a Worksheet: Use add_worksheet() to add a new worksheet or get_worksheet() to access an existing worksheet.

3. Inserting the Image: The insert_image() method is used to insert the image. You need to specify the cell and image file path/attribute where the image will be inserted.

4. Saving the Workbook: Use the save() method to save the workbook with the desired filename.

Image Size and Formatting

When inserting images, consider the size and aspect ratio to fit well within the cells. Resize your image beforehand or use additional methods to adjust its dimensions post-insertion.

Error Handling

Implement error handling to manage scenarios such as file not found, unsupported file formats, or issues with the Excel file itself. Using try-except blocks helps manage exceptions gracefully.

Dependencies and Limitations

While IronXL is powerful, be aware of its dependencies and licensing. Ensure compliance with the licensing terms and be aware of any limitations in the free version.